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.