Week

Jorge Pena

• 26. August 2019 22:02

Hi, 

 

I am looking to set the week date of the year for my labels. 

For example if the today's date is 8/26/19 then week is 35.  I also need to express the result in two digits. "02" etc. 

Thanks! 

 

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • 27. August 2019 08:09

  For the first part you do not VB as if you change your Data Type to Date you can then use the Custom Format command WWW which will convert the date to the week of the year. 

  However this returns a single digit for weeks 1-9 so to convert this press the Transforms tab for this field and select the Use VB and type in this in the box

  If Value < 9 then
  Value = "0" & Value
  else Value = Value
  end if
  Value = Value

  0
• 

  Jorge Pena

  ★ BarTender Hero ★

  • 9. September 2019 23:34

  Excellent! 

  Thank you for the response!

  1

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.