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:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"