IntervalType

building reports crystal reports
1

Hi … anyone who knows whats the different between “y” (day of the year) and “d” (day) in the intervaltype?
as far as this, i never use y, except d. and i dont see the difference there…

For example, the result of
datediff(“d”,{Orders.OrderDate},currentdate)

is the same with
datediff(“y”,{Orders.OrderDate},currentdate)

raccoon (BOB member since 2008-06-19)

2

Hi,

Both both “y” and “d” find the difference in days. If you want to get the difference in years use “yyyy”.

Cheers!!!
Manish

cr_manish :india: (BOB member since 2009-07-30)