hi all,
we have a legacy app written in asp and it is not possible to update it to asp.net. at the moment it stores multiple dates as strings in the format 14/11/2008 for the 14th of November 2008. what i need to do is select out the last weeks transactions based on that date. I have a variable of mdate which is date() - 7 which is fine but trying cdate() on the field in the table doesn't work. any ideas?
~M