I have a SQL database which some date colums all of which are stored as int.
The dates are in Epoch format, ie the length of time since Jan 1st 1970. An example of a value in the column is 16261 which actually equates to 08/07/2014 and 15896 which equates to 09/07/2013. I have tried to use the date formater setting the source date format as %s and also have dowloaded the custom transformer date convertor, but can't see anyway in it to set the source as Epoch time. Any help would be much appreciated, but I do not know how to use phyton scripts.
Regards,
Helen