X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> How To Validate Varchar Field For Yyymmdd, classic    
post Jun 11 2018, 04:42 AM

Posts: 404
Joined: 6-November 02
From: Malaysia

Hi,there. I would like to enquire if i could write a vbscript or javascript that is to verify a varchar field so that it must fit this format YYYY/MM/DD? My page is coded in asp classic.

field :trdate varchar On the page, it was indicated with a remark yyyy/mm/dd..see attached


Attached File(s)
Attached File  Untitled.png ( 5.28K )Number of downloads: 0
Attached File  Untitled.png ( 5.28K )Number of downloads: 0
Go to the top of the page
post Jun 11 2018, 11:33 AM

UtterAccess VIP
Posts: 7,014
Joined: 30-June 11

See: https://stackoverflow.com/questions/1875877...dd-using-jquery

Your RegEx might be more like:


Why not use a date picker?
Why not use a Date/Time data type?

Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    16th December 2019 - 02:08 AM