Solved

Date / Time Validation and formating through script.

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Suggested Solutions

Title # Comments Views Activity
New to FMP 6 143
Filemaker Pro/Advanced licensing, compile and distribute 4 416
Filemaker import xml 3 192
FileMaker - Dropdown menu with checkboxes and multiple choices 4 514
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…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

730 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