Show Month name

[dhborchardt]

I have a list box showing the months. I can get it to display numbers for example 1 2 3 4 5 (instead of Jan, Feb, Mar, April etc). I can also get them to display 1/1/2010. How do I get it to display Jan, Feb, Mar, Apr etc?

[johnw]

Ah, thanks. I could swear you've told me that before, but it apparently didn't sink in the first time. I've changed my settings. That'll simplify the process a bit.

[dhborchardt]

Thanks for the tip on formating.
Here is what I have so far. I am not clear on how to use the LOAD except when I am using it to pull data from Excel. I was able to format the APPLYDATE properly through the properties.
This works to get the year:
Year ([APPLYDATE]) as Year,
But this does not work to get the month
Month ([APPLYDATE]) as Month,

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

ODBC CONNECT TO [MS Access Database;DBQ=N:\Data\McGladrey\ADP\AdpToFastHTest.mdb];
SQL SELECT ABBREVIATIONPCCHAR,
ADDTOTCETOTSW,
ADJUSTEDAPPLYDATE,
APPLYDATE,
Year ([APPLYDATE]) as Year,
Month ([APPLYDATE]) as Month,
CHILDPAYCODEID,
CURRPAYPERIODEND,
CURRPAYPERIODSTART,
DISPLAYORDERNUM,
EMPLOYEEID,
ENDDTM,
HOMEACCOUNTSW,
ID,
ISMONEYAMOUNTSW,
LABORACCTID,
LABORACCTNAME,
LABORLEVELDSC1,
LABORLEVELDSC2,
LABORLEVELDSC3,
LABORLEVELDSC4,
LABORLEVELDSC5,
LABORLEVELDSC6,
LABORLEVELDSC7,
LABORLEVELNAME1,
LABORLEVELNAME2,
LABORLEVELNAME3,
LABORLEVELNAME4,
LABORLEVELNAME5,
LABORLEVELNAME6,
LABORLEVELNAME7,
MONEYAMOUNT,
NEXTPAYPERIODEND,
NEXTPAYPERIODSTART,
NOTPAIDSW,
ORGPATHDSCTXT,
ORGPATHTXT,
PAYCODEID,
PAYCODENAME,
PAYCODETYPE,
PCVISIBLETOUSERSW,
PERSONFULLNAME,
PERSONID,
PERSONNUM,
PREVPAYPERIODEND,
PREVPAYPERIODSTART,
STARTDTM,
([TIMEINSECONDS]/60)/60 as Hours,
TIMESHEETITEMID,
VISIBLEINRPTOPTNSW,
WAGEAMOUNT,
WFCTOTALID
FROM TimeCardData;

[johnw]

The load should come before the SQL select. Please see my earlier post for example code, and the explanation of why the month() function isn't working for you.