setting date using a slash (/)

Nancy Palmquist nlp at vss3.com
Fri Jun 12 09:11:26 PDT 2009


Jeff Harrison wrote:
> --- On Wed, 6/10/09, Richard Kreiss <rkreiss at gccconsulting.net> wrote:
>
>   
>> From: Richard Kreiss <rkreiss at gccconsulting.net>
>> Subject: setting date using a slash (/)
>> To: filepro-list at lists.celestial.com
>> Date: Wednesday, June 10, 2009, 10:50 AM
>> 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.
>>
>> I tested @sk = "/" but it appears that the expansion takes
>> place before @sk
>> captures the key stroke.
>>
>> Any suggestions.
>>
>>  
>>     
>
> Hi Richard.  I assume you are doing your processing when leaving a field that you have defined as a date field.  One obvious answer would be to not define it as a date, but instead use an dummy field defined with a "*".  You can then check for a slash and do any other processing that you need - when you are done, just move the contents into your real date field.
>
> Good Luck.
>
> Jeff Harrison
> jeffaharrison at yahoo.com
>
>
>   
>
>
>       
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>   
Jeff,

Your suggestion is also a good way to collect dates if various formats 
and make them all the same format. 

By taking a date typed whichever way, and applying edits until you hit 
one that passes and makes a legal date you can allow things like:

20090101 and 01012009 in the same field and tell which format the client 
used.  Then make it into the one you want with an edit.

I have a process that uses a dummy field as you suggest and if they type 
a slash, it applies a work date - instead of todays date to appropriate 
fields.  This was a great help with those idiot clients that change the 
system date so they can do last weeks work and so they do not have to 
enter dates.  It made the things that should always be the right date, 
like when I printed an invoice or the date I updated mary's record to be 
the right and real date.  But it let them use the normal way to apply 
today's date but have it be a work date for charges and payments that 
need to be dated on the day they actually happened.  Beautiful thing 
about this method is that on fields that should have today's real date 
the slash applies that, but on fields that might need the work date, it 
applies that date instead.

Default work date is always today, they have a chance to change it as 
they start or at their discretion. They love it, I love it. 

How the heck can you properly age anything if the system date is always 
wonky?  It drove me nuts.  They entered an invoice with the computer 
date set 2 months back and then wondered why it was 2 months old, and 
not paid.  I had to stop this kind of thing and this worked great.

Nancy

-- 
Nancy Palmquist 		MOS & filePro Training Available
Virtual Software Systems	Web Based Training and Consulting	
PHONE: (412) 835-9417		   Web site:  http://www.vss3.com



More information about the Filepro-list mailing list