Count number of weeks/month 1

[Digitelpersona]

Hi,

I'm wondering if it's possible in crystal 11 to count the number of weeks or month between two dates. Would this be done in a formula or does crystal have a built in funtion for something like this?

Thanks,
Joe

 

[synapsevampire]

Sure, just use the Datediff function, as in:

DateDiff ("w", {table.date}, currentdate)

The parameters available are:

yyyy
Year

q
Quarter

m
Month

y
Day of year

d
Day (both "y" and "d" find the difference in days)

w
Number of weeks between startDateTime and endDateTime

ww
Number of firstDayOfWeek's between startDateTime and endDateTime

h
Hour

n
Minute

s
Second

-k

 

[Digitelpersona]

Thank you very much!