How to use DateAdd to work out due date one month from created

[pcoombe]

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 

[Drrickryp]

Hi @pcoombe 

DateAdd(DateTimeValue(Text(DataTable1.Selected.'Created On')),30,Months)

Worked for me. 

[pcoombe]

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

[Drrickryp]

@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.

[pcoombe]

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 

[pcoombe · Accepted solution]

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