I am trying to find the right syntax for the timestamps in Infor BCs, when queried using ISD (I know SQL / Compass would do this, as well as probably BIRST formulas, but this will be a client maintained function, so trying to find an ISD based solution).
My last attempt at a valid date format, to be able to recognize the field, and sort it and use it as a pivot, was
dddd,dd mmmm yyyy hh:mm:ss.000 AM/PM, and the sample value is below (PayablesInvoiceAudit BC, specifically).
| Friday, 06 January 2023 15:21:17.00 PM |
Anyone know what Excel syntax for a custom date format works here? Guess my next step is parse and reconstruct, if needed.
