It is a Date field. They strange thing is I just noticed that this works ok from the web. If I use aruser it creates a record every time. Either I am misinformed about something or this is a bug.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bean Sent: Monday, October 30, 2006 12:33 PM To: arslist@ARSLIST.ORG Subject: Re: Push Field Problem Brian, Is the 'Sign In Date' field a date/time field or a date field? If it is date/time (even if it is only set to display as date-only), then your qualification would only prevent multiple requests from being created for the current user for given second of the day, *not* for the given day. If this is the cause, you should be able to correct this without converting to the date field type by using this modified qualification: ( 'Submitter' = $USER$) AND ( 'Sign In Date' >= $DATE$) HTH, --Thomas ----- Original Message ----- From: "Sokol, Brian" <[EMAIL PROTECTED]> Newsgroups: gmane.comp.crm.arsystem.general Sent: Monday, October 30, 2006 11:11 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"