Problem in calculating diff. of two date fields

HCL Domino Domino Forum
1

hello,

    In my view i have made one column where i am showing diff. of two date fields...It's working fine but i am getting result in seconds....like if diff. is of one day then the output coming is 86400.....but i want the output as 1,,if diff is of one day..... i am using this column formula

y := wrkRqt_planneddate;

x := @Date(@TextToTime(wrkRqt_depHeadAppOn));

z := y-x;

@If(y!=“”&x!=“”; @Text(z);“”)

here “wrkRqt_Planneddate” is date field in form in which user enter’s the value and wrkRqt_depHeadAppOn is text field in which value sets after approval as @today…

i used @businessdays but i am getting -1 as output and i tried to sort out the this with datatypes and @day func. but not getting desired output…

                   can any one give me solution to this asap....

thanks…

Stuti

2

Subject: Problem in calculating diff. of two date fields

Hi Stuti,

Try this…

z := @Integer((y-x)/86400)+1;

Best Regards,

Munish Kaushik

3

Subject: RE: Problem in calculating diff. of two date fields

Thanks a lot munish…

when i used your formula with +1 day was calculating one day ahead…i used this

z := @Integer((y-x)/86400) and i am getting the desired output …