the data is in a vfp table, c(20) field. i need to query that field returning only those with a date after 7 days ago. the dates are in british format. I am using vb script in an asp page.
~M
>
>Are you using VFP data? Perhaps you can run a script using EXECSRCIPT and in this script first set date to British (or any DMY format).
>
>In SQL Server you would use SET SYSFORMAT to DMY for this.
>>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
Go raibh maith agat
~M