Timestamp format

[datanibbler]

Hi,

I have a syntax question which I cannot find the answer to in the help_file:

=> I have a field that comes out of the database as a timestamp in the format 'DD.MM.YYYY hh:mm:ss AM' or 'DD.MM.YYYY hh:mm:ss PM'

=> I know that, generally, to read such a thing I would need the TIMESTAMP# function

=> The question is: How do I specify the 'AM/ PM' as a parameter to this function?

    (the outcome I need is just a date, no time)

Thanks a lot!

Best regards,

DataNibbler

[luis_pimentel · Accepted solution]

If you just need the date, then use Date() or Date#() functions, and forget about the time format.

Hope that helps.

Luis.

[datanibbler]

Hi Luis,

that works like a charm! Thank you!

Now I hope I'm going to get my head around what's going wrong - this was just the first step. Anyway, the longest voyage always begins with the first step 😉

Thanks!

Best regards,

DataNibbler