Convert Long to Date

[ljpitre]

I'm looking at someone elses code that generates keys using dates.

part of his code converts a date type to a long

Clng(Date)

Is there a way to reverse this? that is convert the long back to a date?

 

[johnwm]

Use CDate()

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints