Numeric Value Of A Datetime Field

[TomSalvato]

Hello All,

I have a datetime field and I need to know the numeric value. By 'numeric value' I'm referring to that individual number that all days have since Dec.30,1899. I think it's something like the DateTimeValue function, but I can't find a good example of it in crystal.

-TS

 

[kray4660]

I could not find a function that directly addresses your issue. But I would think that you could use the datediff function (i.e. datediff("d", date(1899,12,30),{date_field}).

 

[jmd0252]

I believe that as long as the field is defined as a "date",, then subtract that field fron todays date, and get the number of days that have elapsed.

 

[kray4660]

That does indeed work.

 

[TomSalvato]

Thanks so much for the replies, guys. I'll give your suggestion a go tomorrow when I get back to my desk! -TS

 

[TomSalvato]

Thanks again!

You guys set me on the right path, and I think I'm there now. Going to go with the 'elapsed days from today' scenario.

-TS