Hi folks.
Does it not really matter if a date in Access is defined as 'text' in the data type column, rather than date/time.
Because this way, I can get ColdFusion to output a list of members held in the database from a certain year, with just the date and not the time and in the correct format of dd/mm/yyyy rather than yyyy/mm/dd, which is what I was getting whn I set joinDate to date/time.
Is it OK that I've used the text format rather than date/time, or will this produce errors somewhere along the line?
Cheers, James