INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...I wish I knew about this site years ago. It would have saved me a lot of heartaches..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Reporting Solutions > Business Objects: Crystal Reports 2 Data Access Forum

datetime returning as a date

Read More Threads Like This One

djieon (TechnicalUser)

18 May 12 5:38

Hi all,

I have a field called RM_INSTRUCTION.INSTRUCTION_TIME this is a datetime field.

when I drag it into a report it returns as expected as a datetime field.

however when I add this table to a report and drag the field onto the page its only returning as a date, and when I right click and browse field data it thinks its a date field.

Is there something really stupid I am doing?!?!?

Thanks.

David.

SkipVought (Programmer)

18 May 12 8:26

My GUESS, as not a CR guy, is that it IS Date/Time, but you have a report FORMATTING issue, because Date/Time can be FORMATTED to DISPLAY DATE only or TIME only or, if the Date/Time were today: Friday May 18 2012 7:24 AM or Fri 18 May 12 07:24 or 5-18-12 7:24:56 or, or, or....

Skip,
_{Just traded in my old subtlety...
for a NUANCE!}

lbass (TechnicalUser)

18 May 12 13:50

What version of CR are you using? Some early versions allowed the user to convert datetimes to dates in file->report options. Also if you open a report in a new version of CR that was created with an earlier version with this option set, you could also see this behavior.

-LB

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Business Objects: Crystal Reports 2 Data Access