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!
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