RainLover
VIP From a land downunder
- Local time
- Today, 11:07
- Joined
- Jan 5, 2009
- Messages
- 5,041
I have no idea what I am doing wrong here.
I have a Query.
DateTracked is a field from the Table. It is of Data Type Date/Time, Formatted as Medium Date.
There are other Fields. Like Breakfast, Lunch and Dinner.
Problem.
I want to display in a separate Column "DateTracked" as a day of the week.
I have the following:
MyDate: Format ([DateTracked], "ddd")
This should display the day of the week as Mon, Tue, Wed etc.
What is it that I am doing wrong.
:banghead:
I have a Query.
DateTracked is a field from the Table. It is of Data Type Date/Time, Formatted as Medium Date.
There are other Fields. Like Breakfast, Lunch and Dinner.
Problem.
I want to display in a separate Column "DateTracked" as a day of the week.
I have the following:
MyDate: Format ([DateTracked], "ddd")
This should display the day of the week as Mon, Tue, Wed etc.
What is it that I am doing wrong.
:banghead: