Solved

how can i validate a date field

Posted on 2010-11-07
6
652 Views
Last Modified: 2012-06-27
I have fields that are a char type, but contents a date in format like 08/11/2010. how can i validate the entry for a valid date?
thanks
0
Comment
Question by:luciliacoelho
6 Comments
 
LVL 8

Expert Comment

by:mikegagnon
ID: 34081113
set the format of the textbox to D?
0
 
LVL 2

Expert Comment

by:GreatSolutions
ID: 34081553
if those fields are textboxes, why not setting their values to {} if it's for data entry?
0
 
LVL 27

Accepted Solution

by:
CaptainCyril earned 500 total points
ID: 34081966
IF CTOD(cDate) = {}
    WAIT WINDOW "Date is invalid"
ELSE
    WAIT WINDOW "Date is valid"
ENDIF
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

Expert Comment

by:IQuittner
ID: 34083688
I agree with Mike that is the easiest solution.  You cannot depend on taking CTOD of a variable because when you check it with the TYPE command it returns date to any value that isn't a date i.e., 01/32/2010... so if you cannot use Mike's suggestion you will not only have to convert it to a date but also check the values in each field MM/DD/YYYY to ensure they are valid for your application.  I have never used CaptainCyril's suggestion and I tested it with an invalid date and it too said it was a date field.
0
 
LVL 27

Expert Comment

by:CaptainCyril
ID: 34084208
My suggestion is a validation. It takes the value of a string date and it will it say if it's valid or not and it also depends on your SET DATE.


? isValidDate(table.field)

.T. means it is valid
.F. means it is not

FUNCTION isValidDate
LPARAMETERS cDate
RETURN CTOD(cDate) <> {}
0
 

Author Comment

by:luciliacoelho
ID: 34085482

CaptainCyril's suggestion solvs the problem.
Ii try to put property format D, mikegagnon suggestion and  the field accept data like: 33/02/2010. how can i do this property format results?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Mysql Search for contact 6 235
How VFP9 apps runs under Windows 8 64 bits? 6 500
Read data from Excel file with Oppen Office automation 6 156
FoxPro comparing columns 2 53
Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

911 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now