Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variable to be start date of current years specific month

Hi community,

How would I make a variable that would be the the date of this years Feb 1st until next years Feb 1st has passed?  This variable will change to next years Feb 1st, 2/1/2013, on that day.

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

How about:

LET vX = YearStart(today(), 0, 2)

-Rob

http://robwunderlich.com

View solution in original post

3 Replies
Nicole-Smith

=if(today()>date('2/1/'&year(today()), 'M/D/YYYY'), date('2/1/'&year(today()), 'M/D/YYYY'), date('2/1/'&(year(today())-1), 'M/D/YYYY'))

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

How about:

LET vX = YearStart(today(), 0, 2)

-Rob

http://robwunderlich.com

Not applicable
Author

I figured it out looking at QV Help, but this is correct.