Solved

Date / Time Validation and formating through script.

Posted on 2006-11-01
1
209 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 125 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

919 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now