How to Format week data as requred

[Buchannagari]

Hi,

i have week data column like below

WEEK 09

WEEK10

WEEK11...

and in the master calendar week data is there like 

9

10

11...

so i want to use this week column as key column but format is not correct 

How to format it week column from the master calendar

---week(TempDate) As Week_key,

Thanks & regards,

Buchannagari.

[Renan · Accepted solution]

Hi,

You can do it in two different ways:

• Converting week in master calendar: 'WEEK ' & Num(Week(TempDate), '00') as Week_key
• Converting the data column: Num(KeepChar(TempDate, '0123456789')) as Week_key

[Buchannagari]

Thank you.