Unix Date Conversion

[Lynn]

I have a ModifyDate field in a table that is in Unix Date
format. When I run my query, I would like this date
format changed to mm/dd/yy so that it clearly shows the
modify date. Does anyone know how to convert the Unix
date to mm/dd/yy format.

Thank you in advance.

 

[Allen Browne]

By Unix date, I'm not sure if you mean a Julian date or a text
representation of yyyymmdd.

The solution will probably involve Mid() and DateSerial(), e.g.:
DateSerial(Left([UnixDate], 4), Mid([UnixDate], 5,2), Right([UnixDate], 2)