Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Show First date of current month in text field

Status
Not open for further replies.
mauricionava

mauricionava

Programmer
Jul 8, 2005
209
US
Hi all, I have a form for reports where you input the start date and end date in two fields for the reports. How can I automatically show the 1st day of the current month in a text field? Thanks
 
Sort by date Sort by votes
Do you mean one of these:

[tt]Date - Day(Date) + 1
DateSerial(Year(Date),Month(Date),1)[/tt]

Or

[tt]Format(Date - Day(Date) + 1,"dddd")[/tt]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Hyperlink Text of a field
Replies
1
Views
123
caykamanj1966
caykamanj1966
ameedoo3000
  • Locked
  • Question
Rename current database
Replies
0
Views
194
ameedoo3000
ameedoo3000
ameedoo3000
  • Locked
  • Question
rename current database 2
2
Replies
31
Views
648
SkipVought
S
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
263
PrimoSteve
PrimoSteve
TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
306
TomSalvato
TomSalvato

Part and Inventory Search

Sponsor

Back
Top