convert me! 54,261,458

[betterdays1]

I inherited a new database in which a "start moment" is recorded like this 54,261,458. First of all I'm not even sure what the heck this is. I'm assuming this must be seconds from X date/time. Have any of you run into this?

I'm also trying to convert the date 37681. I'm assuming that this must be a julian date or something. Anyone ever run into this?

thanks in advance

 

[synapsevampire]

I think that your assumptions are probably correct, but you NEED to confirm this with someone.

To determine the first date, try:

dateadd("s",54261458,cdate(1970,1,1))

The result is from some static date, you need to learn what they used.

Here's the CD paper on Julian dates, again, cofirm what it is you have:

http://support.crystaldecisions.com/library/kbase/articles/c2012088.asp

-