Date formatting question 1

[finbib]

I created the following formula:

MonthName (Month ({INVOICE_DT})) in order to get the name of the month.

Is there a way to get the months to format in month order, as opposed to alphabetical order?

TIA,

Bob

 

[synapsevampire]

I think what you mean is that you want them to SORT in month number order.

Sort the records by {INVOICE_DT}), and display the monthname.

Report->Sort Records

If you're grouping on the monthname, you should change that to group on the {INVOICE_DT} with the For Each Month selection, and again, just display the monthname formula.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[finbib]

Synapse,

Thanks, you are right on the button. Everything worked like a charm.

Bob