How to display the date for every Friday

[#1]

Hello, I am using this line to show the date as of every Monday, but i'd like to show Friday's instead, how would I do that?

Thanks in advance

=Date(WeekStart(APP_LOGIN_DATE), 'MM/DD')

[sunny_talwar · Accepted solution]

May be this

Last Week's Friday (Past Friday)

=Date(WeekStart(APP_LOGIN_DATE, 0, 4), 'MM/DD')

or

This Week's Fridat (Coming Friday)

=Date(WeekStart(APP_LOGIN_DATE, 1, 4), 'MM/DD')

[#3]

This worked thank you. could you please explain what the code is saying?

thanks

[sunny_talwar]

WeekStart function takes 3 parameters, one of which can be used to move the weekstart date up or down. So in order to make Friday the weekstart, I used 4

=Date(WeekStart(APP_LOGIN_DATE, 0, 4), 'MM/DD')

Also, look here:

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/w...