Hello everyone .As I can add 24 hours to a field that contains date and time.My field is called " Date" and contains the following format DD / MM / YY hh : mm : ss pm
24 hours is exactly one day, so you have to use
But this will convert the data into numeric form, so you need to convert it back to the timestamp:
timestamp((Date+1), 'DD/MM/YY hh:mm:ss tt')
hank you very much for your help, it has helped me ! Now, in case you would like to add to that date 16 hours , how I can do ? Thanks in advance .
16 hours is 16/24, or 2/3, so it will be
timestamp((Date+2/3), 'DD/MM/YY hh:mm:ss tt')
It's so easy, thank you very much , í'm new and i have much to learn...
Thank you for your help !!!
Retrieving data ...