Dates and Days

Question

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:

Date127/10/2023ABCXYZ

Output

Date129/10/2023ABCXYZ

Prometheus · Accepted Answer

@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