Hi All,
I am extracting data from Ms-acess to Vba form on spreadsheet control. the spreadsheet shows date column in two formats, as -'dd/mm/yyyy (followed by (')) and mm/dd/yyyy. i have tried to change the format of date filed but it is not effective for 'dd/mm/yyyy formating and mm/dd/yyyy format shows wrong output like May,25 2009 is showing like 25/05/2009
the date field in acess is stored in dd/mm/yyyy format. i have chaged it in text to check the output but output remains same
i want data in dd/mm/yy format please help me to fix this problem, i need it badly
I am extracting data from Ms-acess to Vba form on spreadsheet control. the spreadsheet shows date column in two formats, as -'dd/mm/yyyy (followed by (')) and mm/dd/yyyy. i have tried to change the format of date filed but it is not effective for 'dd/mm/yyyy formating and mm/dd/yyyy format shows wrong output like May,25 2009 is showing like 25/05/2009
the date field in acess is stored in dd/mm/yyyy format. i have chaged it in text to check the output but output remains same
i want data in dd/mm/yy format please help me to fix this problem, i need it badly