topic upper(date(DATE,'DD-MMM-YYYY')) STORE AS NUMERIC FOR SORTING? in App Development

upper(date(DATE,'DD-MMM-YYYY')) STORE AS NUMERIC FOR SORTING?

cmorri1988 — Fri, 04 May 2018 09:29:03 GMT

Hi there, Wondering if I can store upper(date(DATE,'DD-MMM-YYYY')) as numeric for sorting purposes by using other functions within this statement? I already order the table by another field, and cant change the system MonthName variable to uppercase values, as I don't want all date formats to change to uppercase throughout the script. Any help appreciated, Thanks

Re: upper(date(DATE,'DD-MMM-YYYY')) STORE AS NUMERIC FOR SORTING?

YoussefBelloum — Fri, 04 May 2018 09:40:59 GMT

Hi,

how to you want to UPPER numeric values ?

Re: upper(date(DATE,'DD-MMM-YYYY')) STORE AS NUMERIC FOR SORTING?

cmorri1988 — Fri, 04 May 2018 09:52:20 GMT

Yes, I believe I need:

date#(upper(date(DATE,'DD-MMM-YYYY')),'DD-MMM-YYYY')

Thanks

Re: upper(date(DATE,'DD-MMM-YYYY')) STORE AS NUMERIC FOR SORTING?

YoussefBelloum — Fri, 04 May 2018 10:14:47 GMT

I didn't see the MMM part...

Date() is dual data type function, it return also a numeric value behind the value it displays, did you try to sort using only the Date() function ?

what do you have so far ?

Re: upper(date(DATE,'DD-MMM-YYYY')) STORE AS NUMERIC FOR SORTING?

marcus_sommer — Fri, 04 May 2018 11:28:08 GMT

I think you should adjust the standard-variables for this task at the beginning of your script instead of manipulating the date-fields with any string-functions: Format Variable Tweaks

- Marcus

Re: upper(date(DATE,'DD-MMM-YYYY')) STORE AS NUMERIC FOR SORTING?

sunny_talwar — Fri, 04 May 2018 11:48:43 GMT

Try like this in environmental variable

SET MONTHNAMES='JAN;FEB;MAR;APR;MAY;JUN;JUL;AUG;SEP;OCT;NOV;DEC';

and then this

Date(DATE,'DD-MMM-YYYY') as Date