I have the following SQL script
Use Database Name
where c_date < 76745
The date is in Clarion format. I know that it is an integer date and that there is a differance of 36161 from the dates that SQL users. I do not know SQL that well so what I wanted to do is delete all records that are older than 14 days.
So i need to do something like this.
IntegerFormat((Today() - 14 Days)) + 36161
My syntax is all wrong. Just donlt know how to do it in MS SQL.