Date Formula

[bonio16]

Hi,

I need to know how in business object i can calculate the days months and years between 2 dates?

eg -
Date 1 - 07/11/2014
Date 2 - 12/04/1958

Thanks

 

[SkipVought]

hi,

So is that dd/mm/yyyy or mm/dd/yyyy. The former, I expect as you are across the pond from The Colonies. ;-)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[bonio16]

Hi Skip

It's DD/MM/YYYY.

Thanks

 

[Charliy]

What you're looking for is DateDiff. It can return the number of days or years or whatver unit you want between two dates.

Datediff('d',{date1},{date2}) would give you the number of days between the two dates.