WeekandYear

[Nandakishore]

Hi,

Need to calculate previous week along with year (232024) . This should be applicable across years.

Thanks

[binuacs · Accepted solution]

@Nandakishore can you elaborate more on your requirement with some input data and expected output for a better understanding?

[Raj]

@Nandakishore 
please ad some sample input and expected output 
will be in better position to help.

[Nandakishore]

Hi @binuacs & @Raj ,

This week is Week 24 and year 2024. I need a formula to calculate like W232024  .

When we move into next year 2025 in the first week it need to calculate W522024 and there on . 

Thanks 

[binuacs]

@Nandakishore 

[Nandakishore]

Hi @binuacs,

Thanks for this . 

But i need to calculate previous week based on today . 

Thanks 

[binuacs]

'W'+DateTimeFormat(DateTimeAdd(DateTimeToday(),-7,'day'),'%W')+toString(DateTimeYear(DateTimeToday()))

[Nandakishore]

Hi @binuacs,

Thanks again .

Now when i run the solution on 1st week of Jan '25 then it must give W522024 . How to do this .

Thanks  

[binuacs]

@Nandakishore of that you need to give the date manually to the formula and replace the DateTimeToday() with that field

[Raj]

@Nandakishore 
just a small change if it is week 52 then year should be ([year]-1)