WebSmart Code Samples
 

Date Validaton, Conversion & Formatting

Description: This program will accept data into an input field as mm-dd-yy, mm/dd/yy or simply mmddyy. You can enter the date by hand in any format or use the calendar. The date is validated using the alphatodate function and then converted to a numeric value of YYYYMMDD. See the results in RED the table below after you hit submit.

DATE:

Result TypeValue
Date Selected (no special formatting):
Selected Date converted to an 8 Numeric: 00000000

  This example was created using WebSmart.

www.excelsystems.com