Number to date

[ShortyA]

I am trying to convert a numeric value to the date it represents. The numeric is unusual in that it is the number of days since 31/12/1899. Does anyone have any advice on how this could be achieved as I have not come across this before ?

I am using CR Prof 9.2
Thanks!

 

[bdreed35]

Try this in your formula:

DateAdd("d",{table.number_of_days},CDate(1899,12,31))

~Brian