text format to date format

  • Thread starter Thread starter macamarr
  • Start date Start date
M

macamarr

Hello I import a file using the Import Wizard Advance.
When I tried to make the date field Date/Time Format I
recieve Type Conversion Errors. So I bring the date in as
text. I use an input mask for date and that works. What I
need to do in my query is show the actual day of the
week. How can I do it?
 
If the date field is called date1 then add a field to
your query "=Format(DateValue([date1]),"dddd,
mm/dd/yyyy")" which will give you the day of the week as
well as the date. If you want just the day of the week
use "dddd" instead of "dddd, mm/dd/yyyy".
 
I tried what you suggested and was unsuccessful. Is this not working because it is really a text field that looks like a date do to the input mask?
 
If the date field is called date1 then add a field to
your query "=Format(DateValue([date1]),"dddd,
mm/dd/yyyy")" which will give you the day of the week as
well as the date. If you want just the day of the week
use "dddd" instead of "dddd, mm/dd/yyyy".
-----Original Message-----
Hello I import a file using the Import Wizard Advance.
When I tried to make the date field Date/Time Format I
recieve Type Conversion Errors. So I bring the date in as
text. I use an input mask for date and that works. What I
need to do in my query is show the actual day of the
week. How can I do it?
.
Click to expand...
Click to expand...
 
Back
Top