pcsoft.us.windevCopyright 2026, PC SOFT23 Jul 2015 04:43:59 Z21 Jul 2015 04:55:23 ZThis is possibly a newbie question but I am having problems defining a query for reports: I have 2 edit controls in a window: EDT_dStart and EDT_DEnd; both are configured for a returned value of YYYMMDD The query for this report is SELECT..... FROM.... WHERE burial.Burial_Date BETWEEN {EDT_dStart} AND {EDT_dEnd} The query always returns no data but obviously the parameters aren't being submitted in the right format because if I put in their place the values 20010101 and 20101231 the query works. What am I doing wrong? Thanks for the help. Garry30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53156-date-range-for-reports/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)gallen.dbmcpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53156-date-range-for-reports-53194/read.awp23 Jul 2015 04:43:59 ZHot D*amn! I figured it out. First I declared 2 global variables (gdReport_Start and gdReport_End). In the report initializat…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53156-date-range-for-reports-53194/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53156-date-range-for-reports-53194/read.awpdate range for reportsgallen.dbmcpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53156-date-range-for-reports-53187/read.awp22 Jul 2015 16:44:33 ZWell, I figured out the age problem, sort of - I used MONTHS_BETWEEN(Death_Date, Birth_Date)/12 which gives me 2 decimals and I'…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53156-date-range-for-reports-53187/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53156-date-range-for-reports-53187/read.awpdate range for reportsgallen.dbmcpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53156-date-range-for-reports-53169/read.awp21 Jul 2015 20:57:00 ZHi Fabrice Sorry for being so vague. I'm using WinDev20 and HFSQL in Classic mode. I originally created the query in the r…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53156-date-range-for-reports-53169/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53156-date-range-for-reports-53169/read.awpdate range for reportsfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53156-date-range-for-reports-53160/read.awp21 Jul 2015 11:37:49 ZHi Garry, > What am I doing wrong? 1. You are not showing us your code, so we don't know what you are doing 2. you are…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53156-date-range-for-reports-53160/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53156-date-range-for-reports-53160/read.awpdate range for reports