P
pushrodengine via AccessMonster.com
Now, I need to modify the expression:
Between [Forms].[frmReport].[StartDate] And [Forms].[frmReport].[EndDate]
Is there a way to modify the expression above so that:
[StartDate] mm/dd/yyyy
mm=01, dd =01, and yyyy= the year entered
and
[EndDate] mm/dd/yyyy
mm= the month entered, dd= the day entered, and yyyy= the year entered
A date is entered into [StartDate] and [EndDate] from the form “frmReport†in
the format of mm/dd/yyyy.
Thanks Again
Between [Forms].[frmReport].[StartDate] And [Forms].[frmReport].[EndDate]
Is there a way to modify the expression above so that:
[StartDate] mm/dd/yyyy
mm=01, dd =01, and yyyy= the year entered
and
[EndDate] mm/dd/yyyy
mm= the month entered, dd= the day entered, and yyyy= the year entered
A date is entered into [StartDate] and [EndDate] from the form “frmReport†in
the format of mm/dd/yyyy.
Thanks Again