Forum Discussion

myti's avatar
myti
Helper II
9 years ago

Date format problem

Dear Experts,   I have a calculated Measure which is  an output in Date format like 1/1/2017. Once I want to use this output in if condition I can not get the correct answer and "if condition" can ...
Need Help
JoHo_BI's avatar
JoHo_BI
Responsive Resident
9 years ago

Hi Myti,

 

Try converting your measure to a date too, such as:

 

CalculatedColumn=IF(DATE(YEAR([Measure]), MONTH([Measure]), DAY([Measure]))=DATE(2017,1,1),1,0

 

Hope that helps!

  • myti's avatar
    myti
    Helper II
    9 years ago

    Hey JoHo_BI,

     

    Thank you for your response.However,It did not work!

    • JoHo_BI's avatar
      JoHo_BI
      Responsive Resident
      9 years ago

      Hi myti,

       

      What didn't work about it? What responses/errors did it give? 

      • myti's avatar
        myti
        Helper II
        9 years ago

        I dont receive any error,I dont recieve the answer that is expected. I supposed to receive 1 instead of 0  for column_test. Means that the formulah does not work.