Solved

Validate Date CFInput

Posted on 2003-12-04
3
632 Views
Last Modified: 2013-12-24
<CFINPUT NAME="ListingDate" VALUE="#Evaluate('invest.ListingDate')#" TYPE=text SIZE="20" REQUIRED="no" MESSAGE="Check Input" VALIDATE="date">

The above code is from my update(edit) page. What i am doing is showing in the input field the value from my database.

The problem I am encountering:

The date returned is in this format:
2003-09-17 00:00:00.0

I want to format my variable, to show the date in this format:

MM/DD/YY


in my form, the default returned date returns an error after i submit the form, stating it is not in the correct format VALIDATE="date"

So how can i preformat:
"#Evaluate('invest.ListingDate')#"
0
Comment
Question by:zakirdavis
  • 2
3 Comments
 
LVL 17

Accepted Solution

by:
anandkp earned 500 total points
ID: 9880048
<CFINPUT NAME="ListingDate" VALUE="#DateFormat(Evaluate('invest.ListingDate'),'mm/dd/yy')#" TYPE=text SIZE="20" REQUIRED="no" MESSAGE="Check Input" VALIDATE="date">

hth

K'Rgds
Anand
0
 

Author Comment

by:zakirdavis
ID: 9880512
Once again Anandkp, I appreciate your time.
0
 
LVL 17

Expert Comment

by:anandkp
ID: 9880540
My pleasure :)
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
A web service (http://en.wikipedia.org/wiki/Web_service) is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

773 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