Date Field Calculation

(1) Share

Report

Posted on by neill_long

728

Hello,

I have a label in a gallery with the following calculation:

Text(DateAdd(ThisItem.EV_Date, -1))

Is there a way this formula can be amended to state that if EV_Date lands on a Monday, then the date is to show Fridays date, but any other day it is to show the day before date?

thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Heya!

You can use the WeekDay function to check for this:

If( //Starts Sunday, goes from 1 to 7 WeekDay(ThisItem.EV_Date)=2 , Text(DateAdd(ThisItem.EV_Date, -3)) , //Otherwise show the date before Text(DateAdd(ThisItem.EV_Date, -1)) )

This of course only works for a Monday - we are assuming that your users won't be choosing saturday/sunday? If they can choose sat/sun then we need to also accommodate for that in the formula.

Cheers,

Was this reply helpful? Yes No
neill_long 728 on at

Like (1)

Report
Copy link

Link copied!

this is brilliant, thanks very much. works perfectly.

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Happy to help, hope you have a great day!

Was this reply helpful? Yes No