The database has a string which is a date in the format of dd/mm/yyyy (13/03/2014). No, it has not been saved to the database as a proper date/time.
With Low Replace we are able to change the format of this to yyyy/mmm/dd
{exp:low_replace find="/(\d{2})\/(\d{2})\/(\d{4})/" replace="$3/$2/$1" regex="yes"}
13/03/2014
{/exp:low_replace}
Is it possible to apply Nice Date to the date after Replace has done it's thing as nice date won't work with dd/mm/yyyy? Or do we need to use something like Stash to create a variable for Nice date to work with once Replace has converted it?