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
Solved! Go to 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
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
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
User | Count |
---|---|
254 | |
106 | |
96 | |
50 | |
39 |