Forum Discussion
Anonymous
7 years agoNot applicable
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
- tex628Community Champion
FYMaxDateEND =
IF('Query1'[End - Month]>=4 , DATE([End - Year]+1 , 3 , 31),
IF('Query1'[End - Month]<=3 , DATE([End - Year] , 3 , 31))- AnonymousNot applicable
Thank you very much. it's working now