Still having issues with this. Using 200834905 as an example which should equal "22/05/2022 5:25:21 PM"

Given its a unix date which is seconds after 1970 the following should work;

RS("FleetJoinDate").Value = DateAdd("s", Value(7), "1/1/1970 00:00:00")

It comes out as "13/05/1976 11:28:25 AM" though.