Dates and Days

[Ayaanarjun-5885]

Hi, 

I have a report which runs everyday. Report contains the date column as well. I get the report on every Saturday which reflects its own date. But I run it on Monday, so I want the date to be converted in output to Monday's instead of Saturday. It should give me the date of Monday on every Saturday's date. Below is the Example.

Input:

Date	1	2
7/10/2023	ABC	XYZ

Output

Date	1	2
9/10/2023	ABC	XYZ

[Prometheus · Accepted solution]

@Ayaanarjun-5885 In this workflow, I parsed the date field into an actual date then found the number of the day of the week (DateTimeFormat([Date_Actual], '%u') so I could change the date of a Saturday run to the following Monday's date using this expression.

if [Day]='6'

then DateTimeAdd([Date_Actual],2,'days')

else [Date_Actual]

endif

 

 

[Ayaanarjun-5885]

Thank you so much @Prometheus . It worked.