Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Add Day Function ?

Hi, I need help with this script, basically what I need is the date of Today() - 1 In Ansi SQL

This is what Ive got=

Yesterday = Today() - 1;



Yesterday_Ansi = YEAR(Yesterday) + MONTH(Yesterday) + Day(Yesterday) Yesterday= Today() - 1;

Im getting an error on the second Line, becuase it appears that the YEAR, MONTH & DAY Functions expect the Variable Yesterday in date format, but when I use the minus operator it gets saved as an integer.

Any Ideas?

Thank you in advance,

Jose.

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Add Day Function ?

Not positive, but try this:


Yesterday = Date#(Today() - 1)


1 Reply
Not applicable

Add Day Function ?

Not positive, but try this:


Yesterday = Date#(Today() - 1)


Community Browser