Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Date not calculating correctly

Hi everyone,   I'm having a strange issue with a calculated date column and I was hoping you could help. I have a date, month, and year that I then consolidate into one column called "survey end da...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    Give this measure a try instead.

    Survey end date = DATE ( Sheet[Survey end year], Sheet[Survey end month], Sheet[Survey end date])
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hey Anonymous 

I have a theory.

When the day is 31 (or above 12) then it easy to know it is a day.

When it is 9 (or equal/below 12) the engine gets confused.

 

Try to wrap your code with the FORMAT() function.

Something like

Format(DATE,"dd/MM/yyy")

Let us know if it worked.

Thanks!
A