Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to add 100 secs to the datetime for eg. 02/10/2014 5:40:08 PM so that it becomes 02/10/2014 5:41:48 PM. Any help is appreciated
Hi ramko,
try like this.....
timestamp(MyDate + 100/86400)
=Timestamp(now()+0.0011574074087548)
this expression will give u 100 secs forward time
replace now() by field name or variable name and you will get the answer
when you add 1 it is 1 days
so you have to fraction it with 24 hours*60 Minutes*60Secs =86400
Thank you so much.