What format does a date filter need to be in Crystal 2008

system · October 20, 2009, 12:07pm

I am using 01/01/2005 00:00:00 as the date format for a filter in Crystal but I am getting the following error:

Failed to retrieve data from the database.
Details ORA-12801:error signalled in parallel query server P122, instance gl03dm05:ewp11(1)
ORA-01861:literal does not match format string

Any ideas what the correct format should be?

Thanks!

Blowers (BOB member since 2009-09-30)

system · October 22, 2009, 2:07am

Hi,

May I ask how you define the date filter? Did you use the parameter then place it under record filter or directly place date under record filter.

Thanks

nahtanoj (BOB member since 2009-07-08)

system · October 23, 2009, 3:23pm

If using a parameter there are 2 options: date and datetime. Make sure you select the right one.

The date format is yyyy-mm-dd and the datetime format is yyyy-mm-dd hh:mm:ss

mtoedtemeier (BOB member since 2008-07-18)