Format Date on Report (text box) (1 Viewer)

anoo · Feb 15, 2017

Dear Experts:

I use a text box with control field

="Date Range: " & [Forms]![Form1]![txtBeginReportDate] & " to " & [Forms]![Form1]![txtEndReportDate]

to display date on a report.

Is there an easy way to format the date range on report to "Medium Date"? (15-Feb-17)

- test file is attached.

Thank you so much for your help.

Gasman · Feb 15, 2017

Format(yourdate,"Medium Date")

anoo · Feb 15, 2017

Solved. Thank you very much.

4disk · Feb 8, 2019

I can't use it formula: Format([Field Name], "dd MMMM yyyy"

isladogs · Feb 8, 2019

Welcome to AWF.
You are missing an end bracket e.g.

Code:

?Format(Date, "dd mmmm yyyy")
08 February 2019

4disk · Feb 8, 2019

thank you for your respon,
I still get error message/ invalid syntax, is it means like:

="text ........" & Format([field name], "dd MMMM yyyy")

or

="text ........" & [field name] Format(date, "dd MMMM yyyy")

isladogs · Feb 8, 2019

The 2nd version is wrong.
The first version should work providing you are using a real date field name instead of [field name]. It should also be mmmm but it will work with MMMM

So if your date field is called EventDate then you need

Code:

Format([EventDate], "dd mmmm yyyy")

If it still fails after that, try typing ?Format(Date, "dd mmmm yyyy") in the VBE immediate window and check it gives todays date

Format Date on Report (text box) (1 Viewer)

anoo

Registered User.

Attachments

Gasman

Enthusiastic Amateur

anoo

Registered User.

4disk

New member

isladogs

MVP / VIP

4disk

New member

isladogs

MVP / VIP

Similar threads

Users who are viewing this thread