I am creating a crystal dictionary to use in some reports. But what I am finding is that if I use a date/time field in my dictionary and try to use it in my report it is formatted as 2002/04/02 08:06:00:00 If I try to format it in the report it does not seem to be recognized as a date field and only gives me text formatting features. How do I go about creating a dictionary that has dates formatted in the way that I want, or how do I correctly format a date in a report created from a dictionary? I was wondering if I needed to create the dictionary entry using a formula, is so can somebody give me the formula to get 04/04/02 20:06 (military time) out of the above date?
Also I don’t know if this makes a difference but this is being used in a VB application with the Report Runtime Designer.