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

[Anonymous]

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

[tex628 · Accepted solution]

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

[Anonymous]

Thank you very much. it's working now