Date Formatting (TEXT function)

[akharns]

This is a major regression for me.  It's a little embarrassing.  I know I've done this before...

I have a simple demo app with one field, which tries to format a date, using something like Text("Dec 1,2019","[$-en-US]mmm-dd") or Text("12/1/2019",LongDate).  No matter what I use for the date value or for the format, the output is always exactly the input value, with no reformatting. 

What's up with this???   LOL   This should be an easy answer, I think.  There's nothing complicated going on.

[Eelman · Accepted solution]

@akharns wrap your dates in DateValue() ie

Text(DateValue("Dec 1,2019"),"[$-en-US]mmm-dd"), and

Text(DateValue("12/1/2019"),LongDate)

[akharns]

Yep, that does it.  I thought I tried that.  Thanks.