To format date on the report (1 Viewer)

[hfsitumo2001]

Hello, I want to change the format of the text column in my report. The content of the text is this:
=[Forms]![frmReportselection_ReceiptbyItem]![txtstDate] & " to " & [Forms]![frmReportselection_ReceiptbyItem]![txtEndate]

but It can not work, it always show this format mm/dd/yyyy, I want it to format May, 23, 2022.

Anyone can help me?

Thank you,

Frank

 

[MajP]

Try

 ... & format([Forms]![frmReportselection_ReceiptbyItem]![txtEndate],"MMM, DD, YYYY")

 

[hfsitumo2001]

Try

 ... & format([Forms]![frmReportselection_ReceiptbyItem]![txtEndate],"MMM, DD, YYYY")

Thank you, I will try it

Frank

 

[MajP]

Format function (Visual Basic for Applications)

Office VBA reference topic

learn.microsoft.com

 

[hfsitumo2001]

Format function (Visual Basic for Applications)

Office VBA reference topic

learn.microsoft.com

I tried your suggestion MajP, but It did not work. Did I miss something here?:
= & Format([Forms]![frmReportselection_ReceiptbyItem]![txtstDate],"MMM, DD, YYYY") & " to " & Format ([Forms]![frmReportselection_ReceiptbyItem]![txtEndate],"MMM, DD, YYYY")

 

[MajP]

If the first "&" is actually there then remove it.

= Format([Forms]![frmReportselection_ReceiptbyItem]![txtstDate],"MMM, DD, YYYY") & " to " & Format ([Forms]![frmReportselection_ReceiptbyItem]![txtEndate],"MMM, DD, YYYY")

Is this in a calculated control?

 

[hfsitumo2001]

Thank you MajP, this one works. I missed something on the first try
= (Format([Forms]![frmReportselection_ReceiptbyItem]![txtstDate],"MMM, DD, YYYY") & " to " & Format ([Forms]![frmReportselection_ReceiptbyItem]![txtEndate],"MMM, DD, YYYY"))