Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: get time value only from datetime field Post Reply Post New Topic
Author Message
luubi
Newbie
Newbie


Joined: 22 Dec 2010
Online Status: Offline
Posts: 2
Quote luubi Replybullet Topic: get time value only from datetime field
    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
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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
 
IP IP Logged
luubi
Newbie
Newbie


Joined: 22 Dec 2010
Online Status: Offline
Posts: 2
Quote luubi Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.029 seconds.