Date Format to Fortnight.....

[Krispy89]

In a query how would i go about converting a date to a fortnight instead of week

im currently using:

WeekatePart("ww",[Date])

Where the [Date] is the date the worked!

and this gives me the week i know want to convert this to a fortnight as paying people weekly is to much trouble. I cannot find a way to make this query run in fortnight and i do not want to use a form....

i have searched this for ages and cannot find an answer would appreciate any help as i am assuming this is not difficult and i am just missing something.

Thanks
Krispy89

 

[Krispy89]

week: DatePart("ww",[Date])

Sorry smily was added