This queestion can also apply to Queries & Forms.
I understand that the DATE Data Type in varies formats.
eg.
- "ddd" displays the day of the week
- "mmm/yy" displays the month/year
- "q" displays the quarterly
What I don't understand is what if I have a Form which I want t display both the day of the week -&- the Date. Will I need to enter the date twice or how (or can I) just enter in the date once in the Date field & automatically also be entered into my 3-other "Date" Fields?
Will I only need the DATE Field in my Table & create queries to display my other 3-fields: weekday, month/year, & quarterly?
If my DATE Field is named "TDate" what expressions would I need to generate the weekday say in a query?
Much thanks!