web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Formula help - DateAdd

Power Apps

Answered

Formula help - DateAdd

(0) Share

Report

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

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-hanytian-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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
CC-19121430-0 240 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Join the conversation