Get Date

[cyclogenisis]

Hello,

Trying to get the date of the most recent Sunday that has past (or if it is Sunday use that date). Deriving this date in a user variable stage.

Would like the output format of the date to be YYYYMMDD.

thanks!

[qt_ky]

Try using the PreviousWeekdayFromDate() function. Let us know what you try and if you get stuck.

[ray.wurlod]

Try this.

Code: Select all

Oconv(Date() - Mod(Date(),7), "DYMD[4,2,2]" : @VM : "MCN")

The internal format of the date is an integer. Assuming your system is set up with Sunday = 0, the first argument of the Oconv() function above will give the date of the most recent Sunday.
If your system is set up with a different day as the first of the week, simply adjust the arithmetic to suit.

[qt_ky]

Try using the PreviousWeekdayFromDate() function. Let us know what you try and if you get stuck.

[qt_ky]

Ah, I saw the "parallel" type and missed the user variables stage part.

[cyclogenisis]

thanks ray