Date field updates with day

[jamphan]

I have a form field that the user inputs the date in. I have another field that will change this number date to the actual day of the week but this field is dependent on the date field so it does not update in the table. How can I get the day field to update in my table so I can query off of it? Thanks for any help!

 

[Rich]

You do not need a second field in your table, just set the Fomat of an unbound textbox to "dddd" or use the FormatFunction in a query on your original date field

 

[jamphan]

What would the formating in the query look like?

 

[Rich]

NewField:Format([YourField],"dddd")