SkiNLaB
Sep 18th, 2003, 12:57 AM
Heres the background
i have a crystal report which uses a FDF (field definition file) because i want 2 send it recordsets from whatever source i please.
this has worked great with MySQL, and now i am testing it with Access, and the dates aren't displaying. ie i will drag across teh date field and it will not show anything
however if i create a formula casting it 2 a string, it will display. so ahhh ***?
crystal is giving me HEADACHES!
as a last resort i could cast 2 a string, then cast that back 2 a date. but what a pain in the arse, + i use it in alot of formula's hence alot of work.
i have a crystal report which uses a FDF (field definition file) because i want 2 send it recordsets from whatever source i please.
this has worked great with MySQL, and now i am testing it with Access, and the dates aren't displaying. ie i will drag across teh date field and it will not show anything
however if i create a formula casting it 2 a string, it will display. so ahhh ***?
crystal is giving me HEADACHES!
as a last resort i could cast 2 a string, then cast that back 2 a date. but what a pain in the arse, + i use it in alot of formula's hence alot of work.