Date & Time

[#1]

Hi all

I am importing date fields from two different tables from a Firebird database.

Looking at the data types in the Firebird database, they are all just 'Date' rather than 'DateTime'.

However, the fields that I import from Table B result in the time portion of 00:00:00 being added, even though when I load them in to the final table I use the Floor() function.

Obviously, I can just format any data tables accordingly but I would rather have uniform data types, especially for dates.

Can anyone help?

Thanks

James

[hic]

If you use the interpretation functions, you will get numeric values that you can add and subtract. Hence, you should use

     Date#(DateField) + Time#(TimeField)

to get the correct timestamp number. Then you can wrap this in a formatting function to make it look good:

     Timestamp( Date#(DateField) + Time#(TimeField), 'DD/MM/YYYY hh:mm' )

HIC

[Anonymous]

tried, no result... " -" appears in the cells of the records...