LongDate$

Takes one parameter, a Date value

Description:

Returns the Date value given formatted as an easily readable date (Ex. January 1, 2017)

Example:

Using Top Query command:

NewFields            "Date.Received"
Lookup            "Date.Received", "`Biz.Job", `pJob, "`Received", ""
[New] Received | LongDate$ Date.Received

HtmlAlert ("Received: " & Received) 'Received: December 12, 2016

Using Work Query Text command function:

NewFields            "Date.Received"
Lookup            "Date.Received", "`Biz.Job", `pJob, "`Received", ""
Text            "Date.Received", "LongDate", "Date.Received"

'Result: Date.Received: December 12, 2016