[SOLVED] Ok, to the cloud - (FOC177) INVALID DATE CONSTANT: '2011/05/08 00:00:01.000'
Thanks in advance to anyone willing to look at this problem. BTW, I would have provided a CAR example but there is no DT data available in the CAR file.
I have a date range that I use to gather a weeks worth of data for my Across report, I want to include other records outside the date range but replace their schedule date with a common date when the existing date is GT or LT the date range. But I'm having a difficult time getting the DEFINE to play well with this idea. (FOC177) INVALID DATE CONSTANT: '2011/05/08 00:00:01.000'
quote:
-* So here is my Date Range for the Week, Next Week
-* There is a field in my data call SCHEDULEDDATE formated as HYYMDs data looks like '2011/05/09 24:12:02' -* I plan to build a new field with either the SCHEDULEDATE (because it falls within the week of data) or slam the turn of the century into the field -* so that when I present the Week of data, there will be an extra column at the front. I'll label that with the header 'Not,Scheduled'
DEFINE FILE [TABLENAME] NEW_SCHEDDATE/HYYMD = IF(SCHEDULEDATE GE DT('&FR_DATE') AND SCHEDULEDATE LE DT('&TO_DATE')) THEN DT('1900/01/01 00:00:00.000') ELSE SCHEDULEDATE;
DATE_FIX/I8YYMD=NEW_SCHEDDATE; DYWEEK/A12=IF NEW_SCHEDDATEE EQ '1900/01/01 00:00:00' THEN 'Not,Sched' ELSE DOWK(DATE_FIX,DYWEEK); END
TABLE FILE [TABLENAME] PRINT * ACROSS NEW_SCHEDDATE NOPRINT ACROSS DYWEEK AS 'Scheduled Call Dates for Week Ending &WEEKEND.EVAL' ACROSS NEW_SCHEDDATE AS ' ' END
What happens is I get the error message INVALID DATE CONSTANT
quote:
0 NUMBER OF RECORDS IN TABLE= 758 LINES= 758 -****************************************************************************** -* Final data stage for the report * -****************************************************************************** JOIN CLEAR * JOIN TERR_ID IN AGING04 TO TERRITORYID IN LKUPDSTREGN AS J1 END JOIN TERR_ID IN AGING04 TO TERR_ID IN HLDTERR AS J2 END -RUN DEFINE FILE AGING04 LastCall/MDYY = HDATE(DATEEND, 'MDYY'); NEW_SCHEDDATE/HYYMDs = IF(SCHEDULEDATE GE DT('2011/05/08 00:00:01.000') AND SCHEDULEDATE LE DT('2011/05/14 23:59:59.000')) THEN DT('1900/01/01 00:00:00.000') ELSE SCHEDULEDATE; END TABLE FILE AGING04 SUM MAX.ACCOUNTNAME MAX.SCHEDULEDATE MAX.DATEEND MAX.LastCall MAX.ADDRESS4 MAX.STATE COMPUTE NumDays/D6 = HDIFF(MAX.DATEEND, MAX.SCHEDULEDATE, 'DAYS', 'D6'); COMPUTE CallOffset/D6 = IF MAX.NumDays LE 0 THEN (MAX.CALLFREQUENCY + MAX.NumDays) ELSE (MAX.CALLFREQUENCY - MAX.NumDays); NEW_SCHEDDATE AS 'SCHEDULEDATE' MAX.PRIMARYGROUP_ID MAX.PRIMARYGROUPNAME MAX.TERR_ID MAX.CALLFREQUENCY BY REGIONID BY DISTRICTID BY REPNAME BY ACCOUNT_ID ON TABLE HOLD AS HLDCAL END -RUN 0 ERROR AT OR NEAR LINE 521 IN PROCEDURE call_plan_summary_ (FOC177) INVALID DATE CONSTANT: '2011/05/08 00:00:01.000' 0 ERROR AT OR NEAR LINE 534 IN PROCEDURE call_plan_summary_ (FOC003) THE FIELDNAME IS NOT RECOGNIZED: NEW_SCHEDDATE BYPASSING TO END OF COMMAND (FOC009) INCOMPLETE REQUEST STATEMENT
Thank you,This message has been edited. Last edited by: Kerry,