Hi,
Need to calculate previous week along with year (232024) . This should be applicable across years.
Thanks
Solved! Go to Solution.
@Nandakishore can you elaborate more on your requirement with some input data and expected output for a better understanding?
@Nandakishore
please ad some sample input and expected output
will be in better position to help.
'W'+DateTimeFormat(DateTimeAdd(DateTimeToday(),-7,'day'),'%W')+toString(DateTimeYear(DateTimeToday()))
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
@Nandakishore of that you need to give the date manually to the formula and replace the DateTimeToday() with that field
@Nandakishore
just a small change if it is week 52 then year should be ([year]-1)