If Date is between 2 Dates

(0) Share

Report

Posted on by JB0007

308

Hi PowerApps Community,

I want a message and a button to display when a user select a date that is between 2 dates. My current code is this:

If(DatePickerStart.SelectedDate >=Date(2020,9,14) && DatePickerStart.SelectedDate <=Date(2020,12,11), Notify("This is a period of high season. You need to aks for approval to complete your request",NotificationType.Warning,2000);UpdateContext({vRequest:true}));

The UpdateContext is for my hidden button to show. The code works fine if I choose a date between the dates. However, if I choose a date that is not bewteen the dates, the Warning message pop up even though it doesn't have to (the button doesn't show).

Can anyone help me?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

mdevaney 29,989 Moderator on at

Like (1)

Report
@JB0007

I made some small changes to your formula. Please try it out and let me know if the desired result is produced.

If( DatePickerStart.SelectedDate >=Date(2020,9,14) && DatePickerStart.SelectedDate <=Date(2020,12,11), UpdateContext({vRequest:true}), Notify("This is a period of high season. You need to aks for approval to complete your request",NotificationType.Warning,2000) );

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
JB0007 308 on at

Like (0)

Report

Hi @mdevaney thanks for the reply and your help.

I have insert the year 2020 in the date formula, which means that in 2021 I need to remember to change the year to 2021. However, do you know how can I specify the formula to occur every year instead of keep entering the current year?

If it is also possible, to change the date as: the last 2 weeks of September to the first 2 weeks of December. So that I can insert the formula only 1 time.

Thanks in advance.

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@JB0007
Please post as a new forums question and explain in detail. I cannot picture what your app looks like.

Was this reply helpful? Yes No