UK Tax Week

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The UK tax week number 1 starts on the 6th April of every year and finishes
on the 5 April of every year.

What date function do i need to be able to convert a given date into the
current tax week. Also i need to account for week 53.

Any help would be very much appreciated. thanks!
 
What date function do i need to be able to convert a given date into the
current tax week. Also i need to account for week 53.
Click to expand...

DateDiff("ww", DateSerial(Year(Date() - IIF(Format(Date(), "mmdd") >
"0405", 0, 1), 4, 5), Date())

John W. Vinson[MVP]
 
thanks for info. i have had to add a few brackets to get it working

datediff("ww",(dateserial((year(Date() - IIF(Format(Date(), "mmdd") >
"0405", 0, 1))),4,5)), Date())

this works fine for the current date, what part do i change if i want to
change the current date. so if i wanted to find out the week number for the
04th june 2006, where would i put this date?
 
this works fine for the current date, what part do i change if i want to
change the current date. so if i wanted to find out the week number for the
04th june 2006, where would i put this date?
Click to expand...

In place of Date() (all instances).

Or, if you have a date in a Form control, use that control's name in
place of Date(); put the name of the control in [square brackets].

John W. Vinson[MVP]
 
StuJol said:
What date function do i need to be able to convert a given date into the
current tax week. Also i need to account for week 53.
Click to expand...

Consider creating a calendar table with columns for current tax week,
current tax month, current tax year start, current tax year end, etc.
For more hints, see:

http://www.aspfaq.com/show.asp?id=2519

Jamie.

--
 
Back
Top