DateDiff

[azizrasul]

I'm using the DateDiff to calculate various values. I've got everything to work. However I don't know what influence the firstweekofyear has on a calculation. Whatever value I try i.e. 1,2 or 3 I get the same answer. However further in the future I may have a problem because I don't know what affect the firstweekofyear could have.

Can anyone give me an example where changing the firstweekofyear value gives me a different answer.

While I'm on the subject, what is the difference in using the "d" interval symbol as opposed to the "y" symbol.

 

[SydneyGeek]

I don't know what the FirstWeekOfYear parameters do -- check the Help if you haven't already done so. As for the intervals, "d" is days, "y" is years, "w" is weeks. "ww" will give you the week of the year.

Denis

 

[azizrasul]

Can u think of an example that makes the result different when altering the firstweekofyear value because I can't seem to. This leads me to believe that this parameter is invalid.