Can't set Date Properties.

R

Rog

I am working with data that has dates set as text. So in a query I am using
a variable that sets the text to a date suing CDATE. At least I thought it
did. I notice that in forms etc when I try to set the date property to long,
medium etc, there is nothing to choose so presumably it is not a date after
all!

Any idea what I'm doing wrong please.

Cheers.
Roger
 

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

Get the right language when inserting a date 2
VBA - (re-) Set a Table Style 2
FileDateTime function in a query 6
VBA Code to create reminders in Outlook from Excel 0
Incorrect dates when copying from Excel 0
Macro stops running if date is not in past... 3
Special Date Input Settings 2
DateDiff Error Calculating Time if Date Closed is Blank 11

Top