Skip to Content

First day of Month day name in Current year equal to Day Name of previous Year

Hi All,

Could someone please help me in the logic for the below example:

I have 4 columns.

CY_Date, DayName, PY_Date, Day_Name

05/01/2020,Friday,05/03/2020,Friday

All the daynames for CY and PY should be same. First day of current year day name should match previous year dayname irrespective of the date.

I tried

RelativeDate(ToDate([Previous Year RO Close date];"M/d/yyyy");1)

It worked for February and January. However, It is breaking for March. So, Every month its different. One month it is adding 1 day, other month 2 days. So , Could you help me in writing this logic where the "day name of first day of current year matches the first dayname of previous year"

Your help is greatly appreciated.

Thank you!

Amritha..

capture.jpg (70.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Dear Coudld you elaborate...

    you written..

    CY_Date, DayName, PY_Date, Day_Name

    05/01/2020,Friday,05/03/2020,Friday

    or

    05/01/2020,Friday,05/03/2019,Friday.

    (actual)05/01/2020 is sunday. you written friday.

    05/03/2019 is tuesday you written friday.

    tell me your requirement...

1 Answer

  • Posted on 4 days ago

    There is a typo. You can use screenshot as an example.

    Never mind! I got it. I subtracted 364 Days from current year date and I got what I need ..

    Thanks!

    Add comment
    10|10000 characters needed characters exceeded