Solved Add Start Date and End Date to Report Header as a Subtitle (1 Viewer)

[theDBguy]

Thank you so much
View attachment 94774
is there any way to 1-Jan-2021?

Try:

=Format([Enter Start Date], "d-mmm-yyyy")

 

[Khurramshaikh47]

Hi. Sorry, better yet, try this one.

=Format([Enter Start Date], "d mmm yyyy")

Done Thank you so much dear.

 

[Khurramshaikh47]

Try:

=Format([Enter Start Date], "d-mmm-yyyy")

I've added dd for 01

=Format([Enter Start Date], "dd-mmm-yyyy")

 

[theDBguy]

I've added dd for 01

=Format([Enter Start Date], "dd-mmm-yyyy")

Good job!

 

[Khurramshaikh47]

Good job!

Thank you friend

 

[Pat Hartman]

s there any way to 1-Jan-2021?

Please stop using a prompt and switch to a control on the form. Format the control to whatever date format you want. Access will pop up a date picker and it will only accept a valid date. Same for the control on the report. Give it whatever date format you want.

 

[Khurramshaikh47]

Please stop using a prompt and switch to a control on the form. Format the control to whatever date format you want. Access will pop up a date picker and it will only accept a valid date. Same for the control on the report. Give it whatever date format you want.

Sorry I am beginner I dont have Idea that how to use control on the form for this purpose. Can you explain by screenshots or some more details about it. Sorry if I am bothering you.

 

[Pat Hartman]

Create two unbound controls on a form. Name them FromDT and ThruDT. Set the control's Format property to Short Date. Then in the query, instead of the prompt, use

Where ExpenseDT Between Forms!yourformname!FromDT AND Forms!yourform!ThruDT

Using form field references also allows you to validate the date entries before opening the report should you want to but at least telling Access that the controls are dates by setting the format property, Access will ensure that the values re at least valid dates. They may make no sense but they will be dates.

 

[Khurramshaikh47]

Create two unbound controls on a form. Name them FromDT and ThruDT. Set the control's Format property to Short Date. Then in the query, instead of the prompt, use

Where ExpenseDT Between Forms!yourformname!FromDT AND Forms!yourform!ThruDT

Using form field references also allows you to validate the date entries before opening the report should you want to but at least telling Access that the controls are dates by setting the format property, Access will ensure that the values re at least valid dates. They may make no sense but they will be dates.

Thank you very much.
I've Created a new form DateRangeF

2 Unbound boxes

Names FromDT and ThruDT and Format Property Short Date

But I have 2 Questions
In my case what is ExpenseDT?
and where should I put the following statement?

Where ExpenseDT Between Forms!DateRangeF!FromDT AND Forms!DateRangeF!ThruDT

 

[Khurramshaikh47]

Create two unbound controls on a form. Name them FromDT and ThruDT. Set the control's Format property to Short Date. Then in the query, instead of the prompt, use

Where ExpenseDT Between Forms!yourformname!FromDT AND Forms!yourform!ThruDT

Using form field references also allows you to validate the date entries before opening the report should you want to but at least telling Access that the controls are dates by setting the format property, Access will ensure that the values re at least valid dates. They may make no sense but they will be dates.

???