Discussion Board for collaboration related to QlikView App Development.
what will be the output of floor(date(2016,1,1))
Since you added floor, this will show a number (42370)
ok thanks ,how this is calculated?
1 is 01.01.1900 (DD.MM.YYYY) and then each day + 1
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)