Date Syntax

[Alex Motilal]

Hello Everybody.


I am currently developing a Marketing Database for a Textile Company.
Marketing meetings are held every Wednesdays. For the Agenda, Stock Reports and two different Sales Reports are generated. All the reports are based on the Current Week’s Wednesday’s Date.
The reports are generated by pulling the meeting date (Mostly Wednesday date) from the Dialog Box.
My problem is, sometimes due to unforeseen instances, weekly meeting date is either held earlier to Wednesdays or postponed, but all within the week. In such cases when the meetings date, other than Wednesday date is selected, the reports generated, should be based on Wednesday Date. I want to create an unbound text box in the Dialog box and whatever Date I select in the Combo, Wednesday’s date should appear in the Unbound Text Box. Is it possible?
Alex

[RuralGuy]

I think this site should be able to help: http://www.pacificdb.com.au/Support/code_datetime.htm

[Alex Motilal]

Thank you Rural Guy.
The link helped me a lot. So many times you have given me correct solutions. Thanks again.
Alex

[RuralGuy]

Glad we could help.