Create Timestamp Field

[Anonymous]

I have a DATE field and a separate char field which contains time in hhmiss format. How can I create a timestamp field from these 2 fields?

Thanks,

Dinesh.

[Anonymous]

Can anybody help me?

Thanks,

Dinesh.

[pover]

Dinesh,

Try timestamp#(DATE & ' ' & CHAR, 'DD/MM/YYYY hhmmss').

I don't know what you date format is so verify that DD/MM/YYYY correspondes with date format in column DATE. Replace CHAR with the name of the column iwth the time.

Regards, Karl