Week S’abonner

0
Avatar
Jorge Pena

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! 

 

2 commentaires

0
Avatar
Pete Thane
Actions pour les commentaires Permalien

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

1
Avatar
Jorge Pena
Actions pour les commentaires Permalien

Excellent! 

Thank you for the response!

Vous devez vous connecter pour laisser un commentaire.