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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

date

Thanks

Madhu

1 Solution

Accepted Solutions
sasiparupudi1
Master III
Master III

Let vTodaysDate = Num(MakeDate(Year(Today()),12,30));

Let vAdjustDate = $(vTodaysDate) - (MakeDate(2015,12,30)) +1

View solution in original post

4 Replies
sasiparupudi1
Master III
Master III

swap  the variable and the expressions other way round

MK_QSL
MVP
MVP

I am getting 1...

Let vTodaysDate = Num(MakeDate(Year(Today()),12,30));

Let vAdjustDate = $(vTodaysDate) - (MakeDate(2015,12,30)) + 1

tresesco
MVP
MVP

One bracket is missing for today(). Try like:

Let vTodaysDate=Num(MakeDate(Year(Today()), 12,30);

sasiparupudi1
Master III
Master III

Let vTodaysDate = Num(MakeDate(Year(Today()),12,30));

Let vAdjustDate = $(vTodaysDate) - (MakeDate(2015,12,30)) +1