Hi All,
Having an issue with Dates.
Starting from the 'raw data', my Table has a field called property_purchasedate and it is INT(11).
This is from a legacy database as a Unix Timestamp field, for example 1211292000 which translates to 2008-05-20 GMT, and in local time is 2008-05-21 (GMT + 10).
So, in my j-Cook Table I have a field property_purchasedate which is a Date field.Set to Inherit. All good so far.
So when I display my property_purchasedate in my FrontEnd Layout with the Date field I get 2008-05-20. Which is obviously GMT.
How can I change the display of the Date field according to my Local Time (i.e. GMT+10)?
Any pointers, advice, suggestions much appreciated.
Thank you kindly,
Edward.