Format Date Column as MM-dd-YY AM/PM in the query with M?

[Anonymous]

I have a date column with the current date right now using this formula:

= DateTime.LocalNow())

I do NOT want seconds, however, but do want AM/PM shown. I tried the following:

Date.ToText(DateTime.Time(DateTime.LocalNow()), "MM-dd-yy AM/PM")

It simply won't display properly for whatever reason... it results in error

[mahoneypat · Accepted solution]

Please try this formula instead

= DateTime.ToText(DateTime.LocalNow(), "MM-dd-yy tt")

Pat