Announcements
Hi Everyone.
I am trying to apply a Due Date value based on 1 month from created date. I know I can use the following Text( DateAdd( Today(), 1, Months ),"[$-en-GB]dd-mm-yyyy hh:mm" ) but this is based off 'Today'. I want to be able to replace Today() with Created. No matter what I do, I cannot seem to get this to work. Can someone please help me out and let me know how I can create a due date based on Created date + 1 month
Hi @pcoombe
DateAdd(DateTimeValue(Text(DataTable1.Selected.'Created On')),30,Months)
Worked for me.
Hi @Drrickryp
Looking at your formula below, the TEXT section is where I am having problems. Based on your formula I would use the following DateAdd(DateTimeValue(Text(SharePointForm1.Selected.'Created')),1,Month) where your value of Datatable1.Selected is used. I suppose I am trying to work out what Datatable1.Selected is in your example compared to mine. Is the 'Selected' a value?
cheers
Phil
@pcoombe
Yep, I was referring to my datatable in that formula. I would replace it with the name of your gallery. To test it, put a label on the screen and use that formula and see if it works.
hi @Drrickryp
Really appreciate your help here but it just isnt working for me. Not sure where my disconnect is. Really do appreciate your time however.
thanks
phil
Hi @Drrickryp just to let you know I managed to get this to work. I didnt need the Selected part of the formula. Thankyou for you assistance here
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 541
WarrenBelz 434 Most Valuable Professional
Valantis 289
