?
Solved

Can =Date() be trimmed on an Access Report?

Posted on 2011-03-22
2
Medium Priority
?
230 Views
Last Modified: 2012-05-11
Good Morning,
We have an Access (2002) report that contains the =Date()

(Toolbar | Insert | Date and Time| format of 3/22/2011)

This date is actually a part of a Purchase Order number- for example- PO: 55K-3/22/2011

Is it possible to show the date format without the 2011 in the end? To look like this- PO:55K-3/22

Thank you!


0
Comment
Question by:wgraphics
2 Comments
 
LVL 59

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 35190493
Yes.  Use the expression:

  =Format$(Date(),"mm/dd")

JimD.
0
 

Author Closing Comment

by:wgraphics
ID: 35190543
Jim- wow super fast! Works great.
Thanks so much for your help.
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question