DateTime Calculation

[#1]

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

[#2 · Accepted solution]

Hi ramko,

try like this.....

timestamp(MyDate + 100/86400)

[Anonymous]

=Timestamp(now()+0.0011574074087548)

[Anonymous]

this expression will give u 100 secs forward time

[Anonymous]

replace now() by field name or variable name and you will get the answer

[Anonymous]

when you add 1 it is 1 days

so you have to fraction it with 24 hours*60 Minutes*60Secs =86400

[#7]

Thank you so much.