Printable View
Ok, for some reason, i'm tryin to insert fields from a table into a crystal report.
All the fields work fine, but the one field is a formatted date.
Crystal reports sees it as a number, but inserts 0 instead of the date.
the field value = 6/14/1999
so what am i doing wrong here?
i've tried writing a formula to convert the string, but its not working..
I have no idea what i'm doing with crystal report formala, its supposed to be like VB formula's right?
Try a "RIGHT CLICK" on the date field that you dragged into your report then choose <FORMAT FIELD>. There should be a tab for DATE and TIME then select the desired format.
yep, tried that, but the only data formats they had were in reversed order.
I messed around for about half an hour. And it refused to see it as anything convertable... then i removed the datafield (for the 3rd time), reinserted it, and now it works.
I have absolutely no idea what i did lol.