pcsoft.us.windevCopyright 2026, PC SOFT8 Oct 2019 18:57:40 Z26 Sep 2019 13:44:36 ZHi, I'm new with WINDEV24 and I'm facing a difficulty to calculate datedifference in a query, using native sql server connector. There's a WL function for that, but only works with WFSQL datafiles. There's anybody able to help me on this? Thanks in advance. -- Barros30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67295-datedifference-with-native-sql-server/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)BARROSpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67295-datedifference-with-native-sql-server-67317/read.awp8 Oct 2019 18:57:40 ZHI Baltasar, thanks for the tip. It didn't work. I found this solution: Replace SYSDATE by GETDATE(). But I can't use it …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67295-datedifference-with-native-sql-server-67317/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67295-datedifference-with-native-sql-server-67317/read.awpDatedifference with native sql serverBALTASARpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67295-datedifference-with-native-sql-server-67299/read.awp26 Sep 2019 22:31:53 Znot sure, but maybe when you call sysdate function windev uses "DDMMYYYY", "DD/MM/YYYY" format instead of "YYYYMMYY" "YYYY/MM/DD…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67295-datedifference-with-native-sql-server-67299/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67295-datedifference-with-native-sql-server-67299/read.awpDatedifference with native sql serverBARROSpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67295-datedifference-with-native-sql-server-67298/read.awp26 Sep 2019 15:31:09 ZHi Baltasar, thank you for your answer. I'm getting this message error: https://hostimage.windev.io/images/Errormessage_5…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67295-datedifference-with-native-sql-server-67298/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67295-datedifference-with-native-sql-server-67298/read.awpDatedifference with native sql serverBALTASARpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67295-datedifference-with-native-sql-server-67297/read.awp26 Sep 2019 14:50:58 Zmaybe the problem is with dateformat. Try to use "YYYYMMDD" or "DDMMYYYY" , "MMDDYYYY". If the problem is there, then you can …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67295-datedifference-with-native-sql-server-67297/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67295-datedifference-with-native-sql-server-67297/read.awpDatedifference with native sql server