?
Solved

Date / Time Validation and formating through script.

Posted on 2006-11-01
1
Medium Priority
?
223 Views
Last Modified: 2010-04-27
I have a script step that I'm stuck on.  I have a dialog that will show 2 dates and 1 time for editing.  once it's changed (or left the same)  I would like to be able to format the data into a mm/dd/yy format rather than the default mm/dd/yyyy format (by the way, is there a way to change those defaults?)

I would also need to check the validity of these dates.  I was looking at the IsValid but it looks like its just checking for the presence of data in the field and not if its correctly formated unless I'm using it wrong.

I will need to do some other checking as well but if I get through this one then I should be alright on my own again.

Thanks!
0
Comment
Question by:Cruizectrl
1 Comment
 
LVL 6

Accepted Solution

by:
JoJohn2004 earned 500 total points
ID: 17878564
Under the format menu there is a date option. Using this you can format the date in any number of ways. I believe that you can change the default by not selecting any field and then change the date format to the one you want. All subsequent date fields added to the layout should be in the desired format.

If you format the field as date it will check to be sure that it is a valid date before it will accept the change. if this happening during a script step you want to include the "Set error Capture" script step to On. Display a message if an error happens then return the user to the same layout to correct the mistake.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question