Solved

Date / Time Validation and formating through script.

Posted on 2006-11-01
1
212 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
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…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

695 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