I have a problem with changing text to date.
The date variable (dd/mm/yy) that i imported to Access was recognised as text. I have tried the following methods to change it to date format but they are not useful:
1. Open a query and use a built in function "Cdate", but the output is not what i expected. For example, my date is 30/01/07, but output is 1/7/1930, which is totally a wrong date.
2. Change 'Text' to 'Date/Time' from the design view of the table. However, resulted date was still the same as that using method 1.
Please kindly help as i really need a solution so that i can proceed to do my report.
Warm regards,
Vicki
The date variable (dd/mm/yy) that i imported to Access was recognised as text. I have tried the following methods to change it to date format but they are not useful:
1. Open a query and use a built in function "Cdate", but the output is not what i expected. For example, my date is 30/01/07, but output is 1/7/1930, which is totally a wrong date.
2. Change 'Text' to 'Date/Time' from the design view of the table. However, resulted date was still the same as that using method 1.
Please kindly help as i really need a solution so that i can proceed to do my report.
Warm regards,
Vicki