topic Re: Formular for set last friday in App Development

Formular for set last friday

peisenrot — Tue, 01 Aug 2023 11:30:50 GMT

hello,

I would like to create a variable which give me the last friday as a date. But I have no idea how to calculate that.

Best regards

Pia

Or — Tue, 01 Aug 2023 11:46:25 GMT

You should be able to do this using https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/weekstart.htm by specifying the first_week_day optional parameter. Alternatively, you can check the weekday of the date in question and then subtract the appropriate number of days (e.g. two days if it's Sunday) to get the prior Friday.

BrunPierre — Tue, 01 Aug 2023 12:01:16 GMT

Next Friday = Date(WeekStart(Today(1), 1, 4), 'DD/MM/YYYY')

Last Friday = Date(WeekStart(Today(1), 0, 4), 'DD/MM/YYYY')