Author Topic: Biweekly Values  (Read 1747 times)

Offline Abdel

  • Full Member
  • ***
  • Join Date: Apr 2015
  • Posts: 19
  • Forum Citizenship: +0/-0
Biweekly Values
« on: 08 Jun 2015 10:11:03 am »
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!





Offline Abdel

  • Full Member
  • ***
  • Join Date: Apr 2015
  • Posts: 19
  • Forum Citizenship: +0/-0
Re: Biweekly Values
« Reply #1 on: 08 Jun 2015 10:35:25 am »
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

 


       
Twittear