pcsoft.us.windevCopyright 2026, PC SOFT12 May 2005 00:55:00 Z11 May 2005 18:24:00 ZHello, In the Magic definition of date-fields you can use a lot way of storages. For reading by ODBC you had to define the storage as 'YYMD Date', but the default is 'Integer Date'. When you read that storage by ODBC you get a value instead of a date. To preventing conversion within Magic you can use the following command to get the right date : V_Date = IntegerToDate(V_Integer - 657071), where V_date is a date-field and V_Integer is the integer date-field read by ODBC. The IntegerDate holds the number of days from a starting date, but in Magic and WinDev they are not the same. Maybe this is interesting stuff for those who want to convert Magic_Pervasive files to WinDev_HyperFiles, maybe it's not. Kind regards, Teun.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/4209-magic-integer-date-windev-real-date/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)gillpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/4209-magic-integer-date-windev-real-date-4213/read.awp12 May 2005 00:55:00 ZYes, Tuen, So when an OCX is written is VisVeryBasic you must also reload the starting date so WD can cope with it. WorkingDat…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/4209-magic-integer-date-windev-real-date-4213/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/4209-magic-integer-date-windev-real-date-4213/read.awpMagic Integer Date to WinDev Real Date