Skip to Content
0
May 22, 2020 at 04:17 AM

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

92 Views Last edit May 22, 2020 at 04:58 AM 2 rev

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..

Attachments

capture.jpg (70.4 kB)