output of date

[Anonymous]

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

[sunny_talwar]

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

[Anonymous]

ok thanks ,how this is calculated?

[Anonymous]

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

[Anonymous]

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)