How do I print the current/report date and time on reports as well as on receipt templates (POs, PORcv etc)?
- posted
16 years ago
Date and Time on Reports
Loading thread data ...
- Vote on answer
- posted
16 years ago
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:
- Vote on answer
- posted
16 years ago
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"
- Vote on answer
- posted
16 years ago
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 to see the code below and rate me. Begin TitleRow Text = "Generated On " Font = "Arial" FontBold = True FontSize = 10 Color = "Black" End TitleRow
"Alex" wrote: