Date and Time on Reports

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
Reply to
Akber Alwani
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"
Reply to
Alex
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
Reply to
Akber Alwani

Site Timeline Threads

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.