Crystal report 10 - group parameter error when adding date field

[belle99999]

Crystal report 10 - group parameter error when adding date field

I get an error just with th SENRTY field. missing string or not recongnizing. the date field in the database is M/dd/yyyy 00:00:00 AM. when I remove that part of the group parameter it works fine. I would love some help to try an incorporate this! its driving me crazy but I'm no expert!

Switch ({?group} = 'Employee ID', {CW_VW_209_SEN_CALLIN_SHEET.EMPLOYEEID},
{?group} = 'Name', {@FULL NAME},
{?group} = 'Resource Type', {CW_VW_209_SEN_CALLIN_SHEET.JOBTITLE},
{?group} = 'Seniority Date',{CW_VW_209_SEN_CALLIN_SHEET.SENRTY},{”MM/dd/yyyy”},
{?group} = 'Supervisor', {CW_VW_209_SEN_CALLIN_SHEET.SUPERVISOR},
True, " ")

 

[dgillz]

All values of a group must be the dame data type. SENTRY is obviously a date or datetime field.

Is this a Macola question? What is {CW_VW_209_SEN_CALLIN_SHEET.EMPLOYEEID} I can find no such table or view anywhere, in fact there is no table or view anywhere in Macola progression or Macola ES that has a field that contains the word 'SENTRY'.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html