Biweekly Values

[Abdel]

How can I pull bi-weekly date values from a date field?

Currently, I am using the following expression in order to pull week Value-In-A-Year dor each record. It works without issue, however I am interested in bi-weekly values instead:

datepart ({wk},[Docinfo].[DocsTable].[Date Opened])

Thanks so much!

[Abdel]

IGNORE THIS QUESTION.....I found the answer my self.

TO get biweekly date values, I simply need to divide the weekly value by 2

Thanks