Converting two date/time fields to one integer

[dannewestis]

Hi,

I'm combining two date/time fields in a query to an integer. The first field has the date, the second the time. I'd like the resulting integer to be without the opening 0. How can I do that?

That is, these are the two fields:
2006-09-14 (date/time)
15:00:20 (date/time)

And I'd like those two combined to be 60914150020 (integer) in the third field in the query.

Grateful for advice!

 

[FoFa]

Concatonate the string fields from the date/time in the format you want then use CINT to convert it to an integery value

 

[dannewestis]

Concatonate the string fields from the date/time in the format you want then use CINT to convert it to an integery value

Thanks! Worked excellent (after I managed to find the Swedish equivalent... )

 

[Pat Hartman]

You should just add the two fields. Concatenation is for strings.