Access 2010 Report - Display Current Date Time as CCYY-MM-DD@HH:MM

In an Access 2010 Report I have a Field to display the Date defined with the following properties:
Tab Other - Name: F45320DateTime
Tab Data - Control Source: =(Now())
Format Tab - Format: Short Date

This displays the Date correctly as: CCYY-MM-DD

I want to add the time to also display as: CCYY-MM-DD@HH:MM (24 Hour Time.

What is the code to do this?

Thanks,
Bob C.
Bob CollisonSystem ArchitectAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
Change the Format property of the control to:

   YYYY-MM-DD@HH:MNN

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
BTW, this shows you all the different ways you can use the format property:

https://support.office.com/en-us/article/format-property-date-time-data-type-3251a423-3dd7-446e-be65-c7293eddbb43?ui=en-US&rs=en-US&ad=US

 For date/times.

 Also, this:

 https://support.office.com/en-us/article/format-function-6f29d87b-8761-408d-81d3-63b9cd842530

 is a good overview of everything you can do with Format.

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Oops, typo.  Should be:

   YYYY-MM-DD@HH:NN

Jim.
0
 
Bob CollisonSystem ArchitectAuthor Commented:
Hi Jim,

That's perfect!

I did change it to: YYYY-MM-DD@HH:MN so it only display Hours / Minutes.

Thanks,
Bob C.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.