Crystal 4.6 and Date/Time fields 
Author Message
 Crystal 4.6 and Date/Time fields

I have an Access 7.0 database with DateTime fields.  When I pass this info
to CR it only gets DATE.  I also cant find any time manipulation functions
in CR.

Any help greatly appreciated

FanTim



Wed, 19 Apr 2000 03:00:00 GMT  
 Crystal 4.6 and Date/Time fields

Turn OFF report/global option "Convert Date/Time to Date".

This means *all* date, date/time and time fields are returned as STRINGS.
Beware of implications for formatting, formulas and selection criteria.

--
Les Schmalzbach
(remove nospam- to reply).



Quote:
> I have an Access 7.0 database with DateTime fields.  When I pass this
info
> to CR it only gets DATE.  I also cant find any time manipulation
functions
> in CR.

> Any help greatly appreciated

> FanTim



Wed, 19 Apr 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Crystal 4.6 Bundled date/time question

2. Crystal Report 4.6 (Date/Time)

3. Access 7.0 Date/Time Fields not accessible using CR 4.6

4. Crystal Report 4.6 Date Field Problem (Default to 12/30/99)

5. Crystal 4.6 and times reporting

6. Crystal 4.6 and text fields in Access functions

7. Matching system date/time with field date/time

8. ADO with Access Date/Time field not storing the time, just the date

9. Date/Time field & Crystal Reports in VB5

10. Crystal Report 4 - VB4 and Date Time Field

11. Crystal Report 3 - VB4 and Date Time Field

12. Time field in Crystal appears as Date

 

 
Powered by phpBB® Forum Software