Skip to Content
Former Member
Aug 22, 2013 at 07:51 PM

IDT: Date Object is showing Date Time


Hi ,

I have created a date object in IDT , and the Column in the database is also Date Type , but when I make this object and go to show values it shows the values in the screen shot for example 2013-03-15 00:00:00.000 , but actual the values in the database is 03/15/2103 , I have tried trunc and formatdate functions to get rid of the time stamp , but im not able to do that , it keep of showing the same timestamp values, and if I change the data type to Date then after I do Integrity check on this object it throws error as attached .

The reason why I want to make it date type , because I want to show Calendar In the prompt in my report , if I leave it as a timestamp, ,then the Calendar is not coming in the report , the prompt created with Timestamp is also attached in the screenshot ,

so Basically two things

1) - The date object with timestamp is not showing calendar in the prompt in my report.

2)- If I convert the data type of the Date object to Date from Date Time , it gives the calendar in the prompt , but in the Integrity it shows the error attached .