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