system
#1
Hi ,
We have two date time stamp fields, now we want to calculate difference between these two datetime fields.
Like.
Start Date : 16-Dec-2011 10:10:00
End Date : 17-Dec-2011 11:10:00
Difference should be = 1 day 1 Hour 00 Mins.
How to do this, please help on this.
Sasa (BOB member since 2006-04-05)
system
#2
Hi,
This old topic can help you:
You need to convert the DeskI formulas into the WebI format.
Marek Chladny (BOB member since 2003-11-27)
system
#3
Thanks Marek…
I will check.
Sasa (BOB member since 2006-04-05)
system
#4
Hi Marek
Some cases my End Date wil be lesser than start date. In that case that formula is not working ,Can you please help on this.
For Example
Start Date : 16-Dec-11 10:10:00
End Date: 14-Dec-11 08:10:00
Result Should be: -2 days -02:00:00
Sasa (BOB member since 2006-04-05)
system
#5
Hi,
Try using the IF statement to check which date is bigger and then use the relevant formula.
Marek Chladny (BOB member since 2003-11-27)
system
#6
Great Marek …Thanks for your response.
I will try , hope it will help to solve my issue.
Sasa (BOB member since 2006-04-05)