Difference in dates (in days) using Formula Language

HCL Domino Domino Forum
1

Is there a way to calculate the number of days in Formula language between two dates? One of the dates is @Today while the other is a date value.

I have something like ( @Today - DateValueBlah ) right now and it returns nothing.

Thanks!

2

Subject: Difference in dates (in days) using Formula Language

The difference in two date-times is a number of seconds. Divide it by the number of seconds in a day. What do you mean, “it returns nothing”? Are you using @Prompt to see the value? Are you using @Text? Are you sure that you have a value in DateValueBlah?

DateValueBlah := @TextToTime( “1/1/2001”);

@Prompt( [OK]; “a”; @Text( DateValueBlah ) );

dif := @Today - DateValueBlah;

difdays := dif / 60 / 60 / 24;

@Prompt( [OK]; “a”; @Text( difdays ) )

3

Subject: RE: Difference in dates (in days) using Formula Language

Also check out…@BusinessDays( startDates ; endDates ; daysToExclude ; datesToExclude ), the to exclude parameters are optional.

M