Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to change text data type to date data type for calculated column

Hi Community people,

I have created one calculated column for financial year end date using below:

 

FYMaxDateEND = IF('Query1'[End - Month]>=4 , "31/03/" & 

'Query1'[End - Year]+1,IF('Query1'[End - Month]<=3,"31/03/" 

& 'Query1'[End - Year]))

 

But it is in text data type but i want in in date data type format only. what should i modify

Can you guys please help me out from this

 

 

Thanks in advance

 

B V S Sudhakar

 

  • FYMaxDateEND = 
    IF('Query1'[End - Month]>=4 , DATE([End - Year]+1 , 3 , 31),
    IF('Query1'[End - Month]<=3 , DATE([End - Year] , 3 , 31))

2 Replies

  • tex628's avatar
    tex628
    Community Champion
    FYMaxDateEND = 
    IF('Query1'[End - Month]>=4 , DATE([End - Year]+1 , 3 , 31),
    IF('Query1'[End - Month]<=3 , DATE([End - Year] , 3 , 31))
    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you very much. it's working now