Default Values For Weekday and Month

[Chinagroveh]

What are expressions to use in a form in fields bound to
a table that will display weeday name and month name base
on last date entered in a date field? What data type
should the weekday and month fields be in the table?

Thanks

 

[Dirk Goldgar]

What are expressions to use in a form in fields bound to
a table that will display weeday name and month name base
on last date entered in a date field? What data type
should the weekday and month fields be in the table?

If the date itself is stored in the table, the weekday and month names
should not be, because they can *always* be calculated from the date.
Storing them would introduce extra overhead while introducing the
possibility of inconsistency -- suppose the date is updated and the
weekday or month is not. What would you do if you came across such a
record?

Given a date, you can calculate the corresponding day name and month
name using the Format function. For the month name,

=Format([DateField], "mmmm")

For the day name,


=Format([DateField], "dddd")

 

[Chinagroveh]

Thank you very much! That makes my program much better.

-----Original Message-----

What are expressions to use in a form in fields bound to
a table that will display weeday name and month name base
on last date entered in a date field? What data type
should the weekday and month fields be in the table?

If the date itself is stored in the table, the weekday and month names
should not be, because they can *always* be calculated from the date.
Storing them would introduce extra overhead while introducing the
possibility of inconsistency -- suppose the date is updated and the
weekday or month is not. What would you do if you came across such a
record?

Given a date, you can calculate the corresponding day name and month
name using the Format function. For the month name,

=Format([DateField], "mmmm")

For the day name,


=Format([DateField], "dddd")

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.