Got a little confused for a second - this is VB .net, not VFP , right ? ( I you are doing this in VFP there is more of a problem than the quotes :-)
Anyway, try
>
>
>[OrderDate >=']+ e.Day.Date.ToString("dd-MMM-yyyy") + [' AND OrderDate <'] +
>
>e.Day.Date.AddDays(1).ToString("dd-MMM-yyyy") + ['];
>
>( I'm pretty sure the brackets work in VB but should make it clearer to see anyway - I think the double quotes in both the param your passing to ToString and the doublequotes you a re using to build your string are confusing the parser. )
>Hi all !
>Can somebody for me mark pairs of ' which belongs to each other, putting 1 or 2
>behind ' ... ( '1 '2 )
>It should be trivial, but ....
>Regards,
>Gojko
>
>
>
>"OrderDate >='"+ e.Day.Date.ToString("dd-MMM-yyyy") + "'AND OrderDate <'" +
>
>e.Day.Date.AddDays(1).ToString("dd-MMM-yyyy") + "'";
>
>
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
