setting date using a slash (/)
Richard Kreiss
rkreiss at gccconsulting.net
Wed Jun 10 09:46:44 PDT 2009
> -----Original Message-----
> From: Kenneth Brody [mailto:kenbrody at spamcop.net]
> Sent: Wednesday, June 10, 2009 12:38 PM
> To: rkreiss at gccconsulting.net
> Cc: filepro-list at lists.celestial.com
> Subject: Re: setting date using a slash (/)
>
> Richard Kreiss wrote:
> > Is there a way to capture the fact that a slash was used to enter a
date.
> >
> > I have a process that will force any date entered into the field to be
> > posted to a record as the last day of the month. In the case where a
slash
> > is used, the date need to be the current date. So, I need to know is a
> > slash was used.
>
> What if they manually type today's date in its entirety? Do you still
want
> that to be changed to the last day of the month?
>
> Would it suffice to say "if it's today's date, leave it, otherwise make it
> the last day of that month"?
>
> > I tested @sk = "/" but it appears that the expansion takes place before
@sk
> > captures the key stroke.
>
> First, @SK will never equal "/". Second, the last key the user pressed
was
> probably Enter and not "/".
In other words, one can never test a date field for a slash.
Looks like Jeff Harrison suggestion to make this dummy field and
alphanumeric field and then test for the /. Good idea.
My other solution is to test for today's date and if it is, get a
confirmation that this is the correct date. I can then use this answer to
control the posting process value.
Richard
More information about the Filepro-list
mailing list