pcsoft.us.windevCopyright 2026, PC SOFT31 Jul 2018 16:10:04 Z31 Jul 2018 13:51:50 ZI need to create a query which will return two strings from HFSQL table in a readable form. This value must be provided from the query - scheduler control displays the value from the query (no formatting is possible before displaying it) what I need is SELECT … WL.DateToString(SCHEDULE.StartDate, maskSystemDate ) + " " + WL.DateToString(SCHEDULE.EndDate, maskSystemDate) AS Formula2 FROM … I have both date values in the table, but I can not insert the delimiter between two strings. Query editor allows me to enter the following expression ... WL.DateToString(SCHEDULE.StartDate) + WL.DateToString(SCHEDULE.EndDate) AS Formula2 FROM Problem 1: How to add the constant string to the formula (i.e. " ") Problem 2: How to format the date in the desired format [WB23] classic HFSQL30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66420-how-query-formula-concatenate-database-and-constant-strings/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)vvidopcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66420-how-query-formula-concatenate-database-and-constant-strings-66428/read.awp31 Jul 2018 16:10:04 ZThanks Fabrice, but the problem is in quotes !! SINGLE QUOTES MUST BE USED I have expected double quotes since I am calli…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66420-how-query-formula-concatenate-database-and-constant-strings-66428/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66420-how-query-formula-concatenate-database-and-constant-strings-66428/read.awpHow to - query formula (concatenate database and constant strings)fromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66420-how-query-formula-concatenate-database-and-constantstrings-66421/read.awp31 Jul 2018 14:24:52 ZHi, I haven't tried, but it seems to me that you could do something like WL.DateToString(SCHEDULE.StartDate,"YYYY-MM-DD") …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66420-how-query-formula-concatenate-database-and-constantstrings-66421/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66420-how-query-formula-concatenate-database-and-constantstrings-66421/read.awpHow to - query formula (concatenate database and constant strings)