On your View form create a Date/Time field and on the Database tab of that field put the field name in the View Information Name field. (You can then delete your integer field(s) as needed).
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Nall, Roger Sent: Tuesday, October 20, 2009 10:31 AM To: [email protected] Subject: Convert Date/Time ** Hello All, ARS 7.1 patch4 SQL2K WIN2003 I have recently implemented archiving for a new application. The problem I have is how to let users search by date from a view form. The view form points to my archive table in a reporting database. Because the date values in Remedy are UNIX time the field on the view form pointing to the Create Date column is integer not date/time. This makes searching by date pretty hard. I am sure that someone must have come across this and has an easy solution they would not mind sharing. One thought I had would be to create a Date/Time field on the view form that the users could populate than translate the date in that field to an integer and use that to search by. The problem I have is how to convert 1/1/09 to UNIX time. Thanks in advance for any help. Roger Nall Manager, SA Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
