Date and Time on Reports

How do I print the current/report date and time on reports as well as on receipt templates (POs, PORcv etc)?

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
hi Alex, you can use the formula to translate the time: below is the code for you as example: (timesold is the datetime field) in RMs all transaction date field contain also time.
Begin Column FieldName = "TimeSold" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Time Sold" VBDataType = vbString Formula = "replicate('0',2-len(cast(DatePart(Hh,[Transaction].Time) as char(2))))+rtrim(cast(DatePart(Hh,[Transaction].Time) as char(2)))+':00'" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 900 GroupMethod = groupmethodNone ColFormat = "" End Column
"Alex" wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Akber, thanks for your reply but I want the date and time that the report was printed (NOT the transaction time). I would like this on most all of my reports as in "Printed on 11/01/2007 10:48 AM"

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Sorry Alex, I mistakenly posted this to somewhere else i was checking my rating and found this so please have the code: YOu can change <report date> to <Now> see the code below and rate me. Begin TitleRow Text = "Generated On <Now>" Font = "Arial" FontBold = True FontSize = 10 Color = "Black" End TitleRow
"Alex" wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.