topic Re: How to display the date for every Friday in QlikView

How to display the date for every Friday

Mon, 13 Feb 2017 14:29:15 GMT

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')

Re: How to display the date for every Friday

sunny_talwar — Mon, 13 Feb 2017 14:43:27 GMT

May be this

Last Week's Friday (Past Friday)

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

This Week's Fridat (Coming Friday)

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

Re: How to display the date for every Friday

Mon, 13 Feb 2017 14:49:00 GMT

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

thanks

Re: How to display the date for every Friday

sunny_talwar — Mon, 13 Feb 2017 15:59:00 GMT

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/weekstart.htm