Converting Text to Date - Formula

[kispat014]

Hi
Is there a formula where you can convert a text date field to a date field (mmm-yyy)
I have the following formula but it is still a text field and when i do an IF statement its not treating the output as a text.

=TEXT([@[Due Date]], "mmm") & "-" & TEXT([@[Due Date]], "yyyy")

 

[Joe4]

If you want to keep it as a Date value, and not Text, don't use the function you have above. Just pull the Due Date field, as-is, and apply a Custom format of "mmm-yyyy".

 

[DanteAmor]

The title says you want to "Converting Text to Date - Formula".


You can give some examples of what you have as text and what you expect as a result.
Depending on how you have the text we must look for the way to convert to date.