There is a bug related to this, I can't remember if it was corrected in a
5.1.2 patch or in version 6.x possibly...
Essentially, the $DATE$ keyword is resolving to Unix epoch seconds instead
of the correct value for date fields (# of days since Jan 1, 4713 B.C.). As
I recall, the bug only affected using $DATE$ in a workflow qualification
with a date field (the $DATE$ keyword should work correctly as a set fields
value for a date field).
I believe the workaround I used was to set a hidden display-only date field
to $DATE$, then use this field in place of the $DATE$ keyword in the
qualification. For example:
Set Fields:
'zTmpDate' = $DATE$
Subsequent 'Push Field If':
( 'Submitter' = $USER$) AND ( 'Sign In Date' = 'zTmpDate')
HTH,
Thomas
----- Original Message -----
From: "Sokol, Brian" <[EMAIL PROTECTED]>
Newsgroups: gmane.comp.crm.arsystem.general
Sent: Monday, October 30, 2006 11:43
Subject: Re: Push Field Problem
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: [email protected]
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"
