Technical Questions: get time value only from datetime field

Print Page | Close Window

get time value only from datetime field

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11931
Printed Date: 28 Apr 2024 at 10:17am

Topic: get time value only from datetime field

Posted By: luubi
Subject: get time value only from datetime field
Date Posted: 22 Dec 2010 at 10:58am

HI all,

I have a time clocking program. This program record clocking time to a Datetime field in SQL

In my Crystal report, how can I display/format the datetime field so that it only display Time value?

I have Crystal report version 10 & I don't know why I cannot format the field to get time value only.

weird

Replies:

Posted By: DBlank
Date Posted: 22 Dec 2010 at 11:14am

right click on the field

select format field

select the Date Time Tab

select the time format you desire from the list (or customize if needed)

Hit OK

Posted By: luubi
Date Posted: 22 Dec 2010 at 11:27am

thanks, I have corrupted file & that is why I didn't see the time format. I redo the file from scratch & I can see it now

Print Page | Close Window