Change date format

Date is stored as mm/dd/yyyy but should be dd/mm/yyyy

For eg:
11/12/2007 is stored as 12th Nov 2007 but is actually 11th Dec 2007

Solution
The syntax for Date is Date(year,month,day). The position for day and month is changed to give the desired result

Read Full Post »