I just noticed this AL works as I thought it should from the web. If I use the User tool it creates a new record every time. I am on ver 7.0 for aruser, server and MidTier.
Also noticed that if I switch the Push Field If statement to: ( 'Submitter' = $USER$) AND ( $DATE$ = 'Sign In Date') I get an arerror 313 Data types are not appropriate for relational operation -----Original Message----- From: Sokol, Brian Sent: Monday, October 30, 2006 12:12 PM To: arslist@ARSLIST.ORG Subject: Push Field Problem I am trying to create some simple time auditing based upon when forms are opened. I am running an AL with a push fields action to a form. I set the Push Field If to: ( 'Submitter' = $USER$) AND ( 'Sign In Date' = $DATE$) And set If No Requests match to Create a New Request And If Any Request Match to Take No Action. Every time I open the form that triggers this AL it creates a new record even though there are multiple records with my account in the Submitter field and today's date in the Sign In Date field. What am I doing wrong? Brian Sokol Manager, Desktop Services Scholastic Inc. 212-343-6494 [EMAIL PROTECTED] <http://www.scholastic.com> _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"