Difference between Two Datetime Field

system · December 15, 2011, 8:34pm

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 · December 15, 2011, 8:41pm

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 · December 15, 2011, 8:54pm

Thanks Marek…

I will check.

Sasa (BOB member since 2006-04-05)

system · December 16, 2011, 7:13pm

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

Sasa (BOB member since 2006-04-05)

system · December 16, 2011, 7:44pm

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 · December 16, 2011, 7:50pm

Great Marek …Thanks for your response.

I will try , hope it will help to solve my issue.

Sasa (BOB member since 2006-04-05)