Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
dynamic_girl
Creator
Creator

output of date

what will be the output of floor(date(2016,1,1))

4 Replies
sunny_talwar

Since you added floor, this will show a number (42370)

dynamic_girl
Creator
Creator
Author

ok thanks ,how this is calculated?

Anonymous
Not applicable

1 is 01.01.1900 (DD.MM.YYYY) and then each day + 1

dynamic_girl
Creator
Creator
Author

the requirement we hvae some one field (which is calculated of today's date -yesterday's date) ,its working fine for all the dates but its not working for 1st date of the month ,

and the script is as below :

so the calculation in the script is like :

where date(datefield)>=makedate(2017,1,1) and date(datefield)<=makedate(2017,2,20)