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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Last Month Reload time

Hello,

i want to show on the file the month before of the reload time.

i have the following function:  Date(ReloadTime(),'YYYYMM').

if this month the result should be 201707. i want to show 201706

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

Date(ReloadTime()-30,'YYYYMM')

View solution in original post

2 Replies
Frank_Hartmann
Master II
Master II

Date(ReloadTime()-30,'YYYYMM')

dberkesacn
Partner - Creator III
Partner - Creator III

=Date(AddMonths(Date#(201706,'YYYYMM'),-1),'YYYYMM')