Dates appear from nowhere !!!

[Anonymous]

Hi

I am a newbie here, so please excuse me.

I have 2 date fields that I have created an expression that has an if statement as below

=

If(

[1HR Start Date]-[1HR Offer Date]

=0 ,

'0 Days',


)

However for some reason when I filter on this I get additional dates and I cannot understand why.  I have exported to excel to check the formular in excel and it worksWhat am I doing wrong?

Thanks in advance

Phil

[sujeetsingh]

Hi,

Try interval() function as

Interval(Date1-Date2,'dd')

thanks

[Anonymous]

Hi

Both solutions are ok, but Son of Sardars works for me.

The only thing now is that I don't know how to group the days in a chart.

i.e. 0 - 7 days / 8 - 14 Days / 15 - 22 Days etc.

Any thoughts?

Thanks again

Phil

[pgrenier]

Good morning Phil,

I believe the IntervalMatch() built-in function could be of some use to you for this.

Cheers,

Philippe