Member Avatar for M.Waqas Aslam

hello!
i am currently working on a simple file make application , this application read data from foxpro .dbf file , i want to get records between two dates , from date and to date , the invoice date field name is fl02 here is my query but this is not working properly and not showing any record.

select * from TRANS.DBF where fl02 >= '8/1/2012' and fl02<= '8/31/2012'

i this there is nothing wrong with it if i run it in mssql , but may be there is some thing not proper in this query for foxpro , please guide me.

Regards

  • 3 Contributors
  • 2 Replies
  • 134 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by neeraj.shorey
Member Avatar for gusano79

I don't think you use single quotes to delimit dates in FoxPro--IIRC, you need to use curly braces, e.g., {8/1/2012}.

Member Avatar for neeraj.shorey

This is not the right format you used for date. You should use like {^YYYY/MM/DD}. This will work.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.