How to convert total number to Date

[mblc]

How to convert number to Date

Exaple;

total number =5968

to

17 year,2 month, 0 day

thanks

[comment]

Can you explain your request in more detail? "17 year,2 month, 0 day" is not a date. 5968 days would translate to roughly 16 years and 4 months - and I cannot see the logic that would produce the result you want.

[fseipel]

Filemaker represents dates internally as the number of days since 1/1/0001.

Hence, you can just set a field (of type date) equal to 5968, and then use the Month, Day, and Year functions on that field, to return the month, day, and year offsets relative to 1/1/1. Note that this will include leap years. This would give 5/4/17.

If you want to make the returned date relative to some other date, say, January 1, 2010 (733773 days after 1-1-0001), you would instead set date to 733773 + 5968.

There is also a function on Brian Dunning's site that will take a julian date number and convert it to a gregorian or julian date which may be of interest. http://www.briandunning.com/cf/239 -- note commas in function should be changed to decimals.