pcsoft.us.windevCopyright 2026, PC SOFT24 May 2018 19:32:08 Z8 May 2018 05:18:48 ZI having trouble in exporting excel files. I dont know what happen but during the import procedure the date-time value changes to DD/MM/YY HHmmSS instead of MM/DD/YY HHmmSS. [code:wl] FOR glocaliNV_Row = 1 TO iNo_rows tblTempData.fldMacId = xlsData(IDXLSFile,glocaliNV_Row,1) tblTempData.fldDateTime = xlsData(IDXLSFile,glocaliNV_Row,2) // Format Date into MM/DD/YY HHmmSS tblTempData.fldRem1 = xlsData(IDXLSFile,glocaliNV_Row,3) tblTempData.fldRem2 = xlsData(IDXLSFile,glocaliNV_Row,4) tblTempData.fldRem3 = xlsData(IDXLSFile,glocaliNV_Row,5) tblTempData.fldRem4 = xlsData(IDXLSFile,glocaliNV_Row,6) // Write the data to the database HAdd(tblTempData) END [/code] https://hostimage.windev.io/images/sshot-74_6ced6a07dcaa4db7214a27ea26c73163.jpg -- Lance Aquino Mendoza Information Technology Officer I Department of Education Philippines30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65404-windev-20-date-format-change-during-import-hhmmss/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)fromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65404-windev-20-date-format-change-during-import-hhmmss-65592/read.awp24 May 2018 19:32:08 ZHi when you import DATA, you import DATA, NOT it's display format... Your date, in your file is stored as YYYYMMDD, ALWAYS, a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65404-windev-20-date-format-change-during-import-hhmmss-65592/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65404-windev-20-date-format-change-during-import-hhmmss-65592/read.awpWinDev 20 - Date Format Change During Import to DD/MM/YY HHmmSSrobinx1578pcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65404-windev-20-date-format-change-during-import-hhmmss-65589/read.awp24 May 2018 16:47:47 ZI guest no one knows the answer or you don't want to share your idea :-( I really appreciate any help.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65404-windev-20-date-format-change-during-import-hhmmss-65589/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65404-windev-20-date-format-change-during-import-hhmmss-65589/read.awpWinDev 20 - Date Format Change During Import to DD/MM/YY HHmmSS