CDate built in function

S

student

What is the purpose of CDate built in Function and what is the syntex to use
it as default value for date field. Please help.

Joe
 
R

Rick Brandt

student said:
What is the purpose of CDate built in Function and what is the syntex to use
it as default value for date field. Please help.
Click to expand...

CDate() is used for converting non-date values into dates. If you have an
actual date field you don't need it.

Just use Date() or Now().
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FileDateTime function in a query 6
Printing Outline view - formatting lost 0
DateDiff Error Calculating Time if Date Closed is Blank 11
Cdate Function 4
strSQL = " (multiple criteria) 1
Update table from query 2
Advice about error handling function 8
WORD VBA Search and switch to advanced ... 1

Top