Forum Discussion

Riette's avatar
Riette
New Member
5 years ago

Help with Changing date format: Expression.Error: The name 'FORMAT' wasn't recognized.

Hi everyone. I have dates in the format 6/15/2021 for example, which are in text but I can't change the to date type until I replace the format to include zero's so its in this format 06/15/21. Anot...
Need Help
aj1973's avatar
aj1973
Community Champion
5 years ago

Hi Riette 

Have you tried "Using Locale"!

 

Riette's avatar
Riette
New Member
5 years ago

Yes I tried that first but it doesn't seem to work, I assumed it was because the format wasn't right to start with.

  • aj1973's avatar
    aj1973
    Community Champion
    5 years ago

    The source! what type is it?

    Can I see it?