Day Name & Week Number from Date Column

[HubertZieciak]

Hi All,

I have number filed from D365 (decimal) which indicates on which day monthly payment should happen.

I need to show all records where this day is exceeded by 7 days in current month, while the report is checked (today).

How Can I create function where:
         YEAR(current)MONTH(current)DAY(decimal field) + 7 >= Today ?

[Josh_BI_UK]

Hi @HubertZieciak , Could you post a sample of your date data, and an example of the output you are looking for please?

[HubertZieciak]

I have column "Payment day" (decimal) which shows day in a month when payment should be made, i.e. number 29 means payment should be done on 29th of each month.

Now what I really need to check is, if Payment day was exceeded by 7 days (today < Payment day +7).

I can't figure out how to number from decimal column convert/fit into date column/measure.

[PattemManohar]

@HubertZieciak  Please try this as a New Column to create date for your Payment Day field.

PaymentDate = DATE(YEAR(TODAY()),MONTH(TODAY()),Test298Date[PaymentDay])

Then you can add 7 days to the Payment Date to check

Check = IF(Test298Date[PaymentDate]+7<TODAY(),"Y","N")

[HubertZieciak · Accepted solution]

Thanks for help.

Problem was solved in different way.
We added addiotional field in CRM with date I need.

[HubertZieciak]

Thank you Pattem.
I tried this solution, but I got an error:

Column format is set to date: