Joined: 06 Oct 2009
Location: Sri Lanka
Online Status: Offline
Posts: 12
Topic: Date Format issue :( Posted: 21 Nov 2009 at 10:33am
Hi all,
Im doing a VB 6.0 app with CR 9.0
I need to save and retreieve dates in DD-MM-YYYY format.
So i have set the date format of the date time picker to DDMMYYYY and in the database it self the format is defined as dd-mm-yyyy.
Is there any way to define the format in CR ?? i guess thats the issue im having because, say , i need to save the date as 2nd December 2009,
so if i select that particular date, date time piceker's text box value is displaed as 2-12-2009.
And in the database it is stored as 2/12/2009... BUT in the Report it is displayed as 12 th February 2009 :( :(
could anybody please help me on this ... thanks a lot in advance ..
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 23 Nov 2009 at 6:51am
if I understand correctly, the value is being displayed incorrectly in the report. Change the display format. if that doesn't work, then create a formula like:
totext({table.field}, "dd-MM-yyyy") //this works only for a date type field.
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
IP Logged
