date expression

H

Herb

What expression do you use in the text box control source
to produce system dates weekly in a form? In other words
when you access the form it shows the current system
weekdays from the text box.
 
K

Ken Snell

Check out the DateAdd function and the Format function.

WeekdayName = Format(DateAdd("d", 1, Date()), "dddd")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
Descenders clipped 0
Is it possible to use DLOOKUP in a query to bring in a value directlyfrom a control box in a form? 3
Copy previous record into form field 0
Excel does not accept text format! 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Clearing Fields in a Word Form 5

Top