We currently have a customised report running on HQ that gives us a detailed breakdown of all PO's across our stores. The breakdown shows us both the PO Date and the PO Required Date and is in format dd/mm/yyyy. However when the report values are exported into excel using the "Copy as Table" function, both the PO date and PO required date outputs show on occasion as a date&time output in excel i.e. dd/mm/yyyy hr:mm. Is there anyway we can restrict the RMS report values to only output to excel in dd/mm/yyyy format?
Both entries for the PO Date & PO Required Date are shown below:
Begin Column
FieldName = "PurchaseOrder.DateCreated"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "PO Date"
VBDataType = vbDate
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 990
GroupMethod = groupmethodNone
ColFormat =
ColAlignment = flexAlignLeftCenter
End Column
Begin Column
FieldName = "PurchaseOrder.RequiredDate"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Req'd Date"
VBDataType = vbDate
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1050
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignLeftCenter
End Column
Regards
Bruce Straughan
*This post is locked for comments
I have the same question (0)
