Formula help - DateAdd

(0) Share

Report

Posted on by CC-19121430-0

240

Hello Everyone 🙂

Please could you help with the below, i am trying to add a number of month's to a date based on the months being selectable via a dropdown, its coming up with an error when i use the below. Any help is much appreciated.

Formula:
DateAdd(StartDate_dtp.SelectedDate, Value(ContractLength_drp.SelectedText), TimeUnit.Months)

Error:
Expected text or a number. Edit your formula so that it evaluates to text or a number.

Thanks

Chris

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-hanytian-msft Microsoft Employee on at

Like (1)

Report
Re: Formula help - DateAdd

Hi @Appy1 ,

May I ask waht items of the ContractLength_drp?

We made asample for you.

Please try this:
DateAdd(StartDate_dtp.SelectedDate, Value(ContractLength_drp.Selected.Value), TimeUnit.Months)

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
CC-19121430-0 240 on at

Like (1)

Report

Re: Formula help - DateAdd

Hello Tina,

The items of my ContractLength_drp is the below:
SortByColumns(Distinct(Tbl_Funding, Duration),"Value")

What you suggested has worked perfectly though so i thank you very much for your help 🙂

Kind Regards
Chris

Was this reply helpful? Yes No