I am pulling in the Account Expiration Date from Active directory. This date comes over as a string into a text field - due to the number of characters (131908824000000000) I can't use the number field. I need to convert this number to a date that is readable in Jira. I am using an expression toNumber(%{AD Expiration Date})/ 10000000 - 11644473600 which returns the value as 1.5464088E9 when I test the expression. This is showing as 18/Jan/70 3:33 PM in Jira. If I go to an online converter and convert this to a date it shows Wednesday, January 2, 2019 1:00:00 AM. I know I am missing something, but can't figure it out.
