<div>
BTW, this shows you all the different ways you can use the format property:<br />
<br />
<a href="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" rel="ugc nofollow">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</a><br />
<br />
&nbsp;For date/times.<br />
<br />
&nbsp;Also, this:<br />
<br />
&nbsp;<a href="https://support.office.com/en-us/article/format-function-6f29d87b-8761-408d-81d3-63b9cd842530" rel="ugc">https://support.office.com/en-us/article/format-function-6f29d87b-8761-408d-81d3-63b9cd842530</a><br />
<br />
&nbsp;is a good overview of everything you can do with Format.<br />
<br />
Jim.
</div>


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 [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 [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.

<div>
Oops, typo. &nbsp;Should be:<br />
<br />
&nbsp; &nbsp;YYYY-MM-DD@HH:NN<br />
<br />
Jim.
</div>


Oops, typo.  Should be:

   YYYY-MM-DD@HH:NN

Jim.

<div>
Hi Jim,<br />
<br />
That's perfect!<br />
<br />
I did change it to: YYYY-MM-DD@HH:MN so it only display Hours / Minutes.<br />
<br />
Thanks,<br />
Bob C.
</div>


Hi Jim,

That's perfect!

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

Thanks,
Bob C.

<div>
<div class="content wysiwyg-content">
In an Access 2010 Report I have a Field to display the Date defined with the following properties: <br />
Tab Other - Name: F45320DateTime<br />
Tab Data - Control Source: =(Now())<br />
Format Tab - Format: Short Date <br />
<br />
This displays the Date correctly as: CCYY-MM-DD<br />
<br />
I want to add the time to also display as: CCYY-MM-DD@HH:MM (24 Hour Time.<br />
<br />
What is the code to do this?<br />
<br />
Thanks,<br />
Bob C.
</div>
</div>


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.

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

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.