Using week Function

[Sai_Mohan]

Hi all,

I have doubt of creating week function, which should show "yearweekdate ".

In my case, I need to calculate week function where I need to get values as weeks

For example: Assume using year as '2019' and the week will be like '17th week '.

it should display like this:      '2019W17'--- here 17 is number of my week.

[JordyWegman · Accepted solution]

Hi,

If your field contains really the '17th week', use this formula:

Year & 'W' & Left(Week,2) as YearWeek

If you have a Date field, like 31-12-2019, use this formula:

Year(Date) & 'W' & Week(Date) as YearWeek

 Jordy

Climber

[Sai_Mohan]

Thank you Jordy