Completely stupid question, which is likely why I can't see an obvious answer on here, but how do you make a timestamp field?
I have a date, and a time, and I'd like it to be formatted like 'DD/MM/YYYY hh:mm:ss'
I've tried timestamp(Date&' '&Time,'DD/MM/YYYY hh:mm:ss') with no success. I know this is really simple, so sorry for the stupid question!
Solved! Go to Solution.
you should use Timestamp# before Timestamp to interpret your fields like a Timestamp, like this:
Timestamp(Timestamp#(your_date_field&your_hour_field, 'DD/MM/YY hh:mm:ss'))
don't we need to use the Timestamp#() function when we want to evaluate non Timestamp field(s) as a Timestamp ?
Or it is just another trick you used here ?