I trust that you are well.
I am struggling with the add date formula
DateAdd(DatePicker3.SelectedDate, 30, Days)
I receive an error below.
Solved! Go to Solution.
Very good - you can't reference a control like that though.
You will need: DateAdd(DatePicker2.SelectedDate, Value(Date_Estimator_Lbl.Text), Days)
Where are you trying to use this formula?
I am using a datepicker (StartDate) + dropdown of the total duration = End Date.
I have tried the formula below. But it doesn't work.
So, not really an answer to the question...Where are you trying to use this formula? What control and property are you putting this formula in?
Okay, so your formula is perfectly fine. It should not be giving you any errors on the Label Text property.
Are you in a non-US region? Perhaps your formulas need semicolons and not commas:
DateAdd(DatePicker2.SelectedDate; 30; Days)
Yes i am based in a Non US region.
I have tried the formula's below. They not working. Can you please tell me where am i going wrong. I have tried removing the commas and replacing it with semi-colons but it doesn't work.
The last picture is definitely an issue, but we need to get the first one working as that is where the real problem is.
Place a NEW label on your screen and set the Text property to:
DateAdd(Now(), 30, Days)
no go? Set it to:
DateAdd(Now(); 30; Days)
What do you get and with which one?
Success!!! So there is something about your DatePicker control.
And...I'm not sure what is your datepicker control. In the original post you mentioned datepicker3 but showed a formula image with datepicker2 then in your first reply to me, you mentioned datepicker4...so what is it?
All of your formula images you have sent have shown DatePicker2 and none of the others. So what is it about DatePicker2 and is that really what you want?
If so, then change your Test label Text property to : DatePicker2.SelectedDate what does that show?
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.