In the GeneralLedgerTransaction business class we have a field called update stamp which in LPL pulls back the correct date and time on the GeneralLedgerTransactionList only using update stamp, which looks like this.
However, I am trying to use this same field or update stamp.timestamp in IPA and I get something like this 2024013100003165.I've attempted several ways to translate the UTC date to central time 'America/Chicago' with no luck. You cannot use the javascript function,<span class="hljs-title function_">toLocaleString, because it only returns UTC time since this is the local time in IPA. I've attempted to get the offset from the timezone business class but the problem with that is some days are during daylight savings time while others are not. So I can do this right now but everything prior to the March date when it changes is an hour off
I have a range of dates within a calendar year and I need to be able to use a function to determine if the offset is going to be 300 or 360.
I attempted to use corporate date in an LPL config but that only gives me the date and the guide doesn't have anything for time unless I am missing something. I used a derived field to get the stamp
type is Date
return update stamp.timestamp
I mixed up the types and the only one that works for this is Corporate Date but that doesn't give the time, just the date.
type is Date
return update stamp.timestamp Corporate Date
