pcsoft.us.windevCopyright 2026, PC SOFT8 Apr 2015 13:28:00 Z6 Apr 2015 13:35:00 ZI am developing a mobile app for Android using WM17. I want to build a SQL statement that will fetch records only for a given month irrespective of Year by querying the date field in the data file. But I am not able to do this. How can we write SQL statement that will do this? TIA Yogi Yang30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51359-hfsql-query-for-particular-month-date-field/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51359-hfsql-query-for-particular-month-date-field-51422/read.awp8 Apr 2015 13:28:00 ZAnyways I have solved the problem in a different way. Instead of trying to retrieve data based on Month I have built the quer…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51359-hfsql-query-for-particular-month-date-field-51422/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51359-hfsql-query-for-particular-month-date-field-51422/read.awpHFSQL - Query for a particular Month in Date Fieldguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51359-hfsql-query-for-particular-month-date-field-51401/read.awp7 Apr 2015 14:37:00 Zwhat are the error? Regards Allardhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51359-hfsql-query-for-particular-month-date-field-51401/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51359-hfsql-query-for-particular-month-date-field-51401/read.awpHFSQL - Query for a particular Month in Date Fieldguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51359-hfsql-query-for-particular-month-date-field-51378/read.awp6 Apr 2015 17:04:00 ZAllard, Thanks for the tip. But I have already tried this and it is not working so I had to post here as the last resort. …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51359-hfsql-query-for-particular-month-date-field-51378/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51359-hfsql-query-for-particular-month-date-field-51378/read.awpHFSQL - Query for a particular Month in Date Fieldguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51359-hfsql-query-for-particular-month-date-field-51377/read.awp6 Apr 2015 16:43:00 ZIf your db is in hfsql you can use substr. for april: where substr(yor_date_field,5,2) = '04'https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51359-hfsql-query-for-particular-month-date-field-51377/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51359-hfsql-query-for-particular-month-date-field-51377/read.awpHFSQL - Query for a particular Month in Date Fieldguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51359-hfsql-query-for-particular-month-date-field-51376/read.awp6 Apr 2015 16:35:00 ZHi Yogi In sql ther is a statement LEFT. This you can uses for instance to get the year use: Left( file.datefield, 4 ) …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51359-hfsql-query-for-particular-month-date-field-51376/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51359-hfsql-query-for-particular-month-date-field-51376/read.awpHFSQL - Query for a particular Month in Date Field