Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: UK Date Format Post Reply Post New Topic
Author Message
Grifter
Newbie
Newbie


Joined: 02 Jun 2009
Online Status: Offline
Posts: 32
Quote Grifter Replybullet Topic: UK Date Format
     Posted: 16 Jun 2010 at 4:57am
Hi

In CR9 does anyone know how I can format a date value into:

DD/MM/YYYY 00:00

All the formatting options seem to be for the USA: MM/DD/YYYY

The value i'm returning is from SQL Server and value has milliseconds and everything else on it and so I want to strip this out to just leave the hours and seconds.

Thanks

G


Edited by Grifter - 16 Jun 2010 at 4:58am
IP IP Logged
saoco77
Senior Member
Senior Member


Joined: 26 Jun 2007
Online Status: Offline
Posts: 104
Quote saoco77 Replybullet Posted: 17 Jun 2010 at 2:09am
Under Format Field on the Date/Time tab there should be a "Customize" button.

This section should allow you to reconfigure the date format as needed - at least it does in CR11.

Hope this helps.
IP IP Logged
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