Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
5 years ago
Solved

Year Week Number

I would like to add the Year Week Number into my calendar so I can differentiate between year cross overs.

I already have a column like:

Fiscal Year = 2019

Fiscal Week = 01

 

Since the column "Fiscal Week" I need some workaround to get a whole number for YearWeek.

But how?

How would you add a combination of the year and week number as a sequential column?

A multiplication or with FORMAT?

 

 

Need Help
  • AnkitKukreja's avatar
    AnkitKukreja
    5 years ago

    Hi joshua1990 

     

    I generally use 2019 * 100 + 1 that would give you 201901 ; 2019 * 100 + 2 = 201902 and so on.

     

    I think this would help you achieve what you want to.

     

    Thanks,

    Ankit

2 Replies

  • AnkitKukreja's avatar
    AnkitKukreja
    Super User
    5 years ago

    Hi joshua1990 

     

    I generally use 2019 * 100 + 1 that would give you 201901 ; 2019 * 100 + 2 = 201902 and so on.

     

    I think this would help you achieve what you want to.

     

    Thanks,

    Ankit

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    joshua1990 ,

     

    I believe you already have a week number column.

    Do you want to concatenate year and week?

     

    Appreciate your kudos !! Mark this post as solution if this helps.