Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to display the date for every Friday

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

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

3 Replies
sunny_talwar

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

Not applicable
Author

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...