Forum Discussion

joshcomputer1's avatar
joshcomputer1
Helper V
8 years ago
Solved

formatting week number in data table

I have a date table and am trying to get the week number to output two digits every time. I currently have the formula below, but the output will just have one digit if the week number is a single di...
Need Help
  • CristinaLia's avatar
    CristinaLia
    8 years ago

    Hi joshcomputer1,

     

    Try this ?

     

    "WeekNum",FORMAT(WEEKNUM([date],2),"00")& "/" & FORMAT ( [Date], "YYYY" ),

    Regards,

     

    Cristina

CristinaLia's avatar
CristinaLia
Frequent Visitor
8 years ago

Hi joshcomputer1,

 

Try this ?

 

"WeekNum",FORMAT(WEEKNUM([date],2),"00")& "/" & FORMAT ( [Date], "YYYY" ),

Regards,

 

Cristina