Weeks remaining till year end

[fkavanagh]

Hi all,

I did a search and thought I would be hit by a dozen or more posts but can anybody give me a formula to calculate the weeks remaining in a year. Obviously on jan 1 I want it to say 52 etc.

Rgds

Fergal

 

[fkavanagh]

I put it in as a SQL expression (first time using this functionallity) for interest what would the formula using crystal syntax be.

select (to_date('31/12', 'dd/mm') - to_date(to_char(sysdate, 'dd/mm'), 'dd/mm')) / 7 from dual

Fergal

 

[danausten]

In a formula use :

datediff("ww",currentdate,date(year(currentdate),12,31))