Delete Within Date Ranges 1

[edrossi]

I am trying to execute this statement, but the records that fall into the range are not being marked for deletion. Any ideas:

store date()-730 to year2
store date()-365 to year1

delete from alias() where between(date,year2,year1)

Thanks

E Rossi

 

[rgbean]

Ed,
Is the field really "date"? Have you tried:
DELETE FROM ALIAS() WHERE date BETWEEN year2 AND year1
Sometimes SQL statements require SQL syntax - the Between() function is strictly FoxPro.

Also is the tablename the same as the current ALIAS(), this statement wants a REAL table name not just an alias.

Rick

 

[ramani]

HI

USe the command..

DELETE IN ALIAS() FOR BETWEEN(date,year2,year1)

Hope this solves your problem

ramani

 

[DSummZZZ]

Also remember that the currently selected table cannot be at EOF() or the records won't get deleted.

Dave S.

 

[Vegetta]

you may use "Locate" or "Go Top" before issuing the command. Continuation for the comment that dsumzzzz suggested!!!

 

[danceman]

check your field type it may be T type which is data and time together. If this is the case use TTOD(table date field )
Returns a Date value from a DateTime expression
Attitude is Everything