About koonseng.neo

Thanks for your quick reply. ... View more

Hi JoergSchuetter,   I have the similar issue after exporting out my Global Protect Remote user list. I try your solution to input your formula "=(A1-Date(1970,1,1))*86400" inside a new cell in excel, where :-  i) A1 is the value of the user login date become numbers (eg. 1586828881)   The result is exponential figures. (eg.  1.37E+14)   I change the multiply (*) to division (/) "=(A1-Date(1970,1,1))/86400, it looks more like a date after formatting. The problem is, I got the "day" 2 days earlier and the "year" 70 years earlier. For example, login date = 14/4/2020. After the formula, I got login date = 12/4/1950   I am using Palo-Alto FW P3020. Can you advise further ? Thanks.  ... View more