Question: Concerning Date/Time fields, have past practices ever involved using text fields for date/time data? Would this cause problems for future queries?
Reply from Alex Hedley:
Access has a data type of DateTime especially for Date Times, If you use Text you will run into lots of problems later. Yes you can use CDate to convert your String to a Date, but why go through that hassle.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 1.
