Converting to timestamp

[Greg Hains]

Hi,

 

I have need to combine a date field and time field into a single timestamp field so I can calculate "time-since" figures. How do I go about this please - I know it's not as simple as table::date & " " & " " & table:time and calculating on that because a timestamp is a number (in the background).

Can I simply subtract 01/01/0001 00:00:01 AM from another time/date field?

Any ideas please?

 

Greg

[LaRetta]

Hi Greg,

 

If you have a date field called theDate and a time field called theTime, you can make a timestamp as:

 

Timestamp ( theDate ; theTime )

 

[Greg Hains]

Hi LaRetta,

 

Thank you. The answer was so simple I'm now embarassed. lol

 

Cheers,

Greg