Just create a Date field on the view form and tell it that the field is your JOURNAL_ENTRY_DATE field.
i.e. Create a regular Date/Time field on the View form and on the Database tab type in the DB View's field name exactly (yes case does matter here). Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Wednesday, April 04, 2007 12:33 PM To: [email protected] Subject: View Forms and Oracle Data Types I created a SQL View: SELECT Vendor as V, sum(RECORD_AMOUNT) as SUM, Journal_Entry_Date FROM TIP_MONTHLY_BILLING_DATA Group by Vendor, JOURNAL_ENTRY_DATE; I created a View form and the Journal_Entry_Date is coming out like: 1060920000 or 1151640000. When I look at the data types from my SQL View the JOURNAL_ENTRY_DATE got automatically set as NUMBER(15,0). Is there anyway to convert this in the VIEW form or else in my SQL VIEW to a normal looking date? Thanks in advance!! Lisa _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
