Hi,
What is the right syntax for BETWEEN with two DateTime values (in SQL Select called from VFP app)? I am using the following syntax and getting an error:
TableName.FieldName between {^2010-04-01 00:00:00} and {^2010-05-01 00:00:00}
The error I am getting is "Syntax error or access violation"
What am I doing wrong?
TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham