January 6th, 2004, 06:32 PM
|
|
Junior Member
|
|
Join Date: Jan 2004
Location: UK
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Exporting Date Conversion From As400
COULD SOMEONE PLEASE HELP!!!
I AM TRYING TO CREATE A CRYSTAL REPORT, BUT THE DATE FIELD WITHIN THE AS400 DATABASE DROPS ALL LEADING ZERO'S. E.G
FOR THE 13/01/00
FORMAT YY/MM/DD, 00/01/13 EXTRACTS AS 113
WHEN IT IMPORTS INTO CRYSTAL IT WON'T RECONISE IT AS A DATE FIELD.
I'VE TRYED TO CONVERT IT TO A STRING , BUT THAT ALSO DIDN'T WORK AS THE 13/01/99 DISPLAYS AS 990113
PLEASE HELP!!!
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
