What is the relation between number "41794" and todays date(i.e 04/06/2014)?
date, java, time
Solution
It looks like the number of days since 1 Jan 1900, possibly with a leap year screwup or two.
Take a look at http://www.timeanddate.com/countdown/to?p0=198&year=1900&month=1&day=1&hour=0&min=0&sec=0
Microsoft Excel uses a system like this. Google "Excel serial date".
Problem
I am trying to extract the id `41794` from a website. But the said number depends on the start date(today's date). See snippet below from the site, 'index.cfm?fuseaction=c_availabilityGrid.displayAvailabilityGrid&startDate=41794&timeSpan=ww,2&showBeds=1&showMlos=0&showprice=1' I am interested to know how the value `41794` is obtained from today's date so that i can put that logic in my code. Is there any function in java which takes input as date and returns the number as mentioned above? Any help in this matter would be greatly appreciated.