|
Inicio → WINDEV 2024 → WinDev 20 - Date Format Change During Import to DD/MM/YY HHmmSS |
WinDev 20 - Date Format Change During Import to DD/MM/YY HHmmSS |
Iniciado por Lance1578, mai., 08 2018 5:18 AM - 2 respostas |
| |
| | | |
|
| |
Membro registado 1 mensagem |
|
Publicado em maio, 08 2018 - 5:18 AM |
I 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.
FOR glocaliNV_Row = 1 TO iNo_rows tblTempData.fldMacId = xlsData(IDXLSFile,glocaliNV_Row,1) tblTempData.fldDateTime = xlsData(IDXLSFile,glocaliNV_Row,2) 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) HAdd(tblTempData) END
-- Lance Aquino Mendoza Information Technology Officer I Department of Education Philippines |
| |
| |
| | | |
|
| | |
| |
Publicado em maio, 24 2018 - 4:47 PM |
I guest no one knows the answer or you don't want to share your idea I really appreciate any help. |
| |
| |
| | | |
|
| | |
| |
Publicado em maio, 24 2018 - 7:32 PM |
Hi when you import DATA, you import DATA, NOT it's display format... Your date, in your file is stored as YYYYMMDD, ALWAYS, and the display format has nothing to do with
So, just change the display format to whatever you want either at the project level or the control level.
Best regards
-- Fabrice Harari International WinDev, WebDev and WinDev mobile Consulting
Free Video Courses, free WXShowroom.com, open source WXReplication, open source WXEDM.
More information on http://www.fabriceharari.com
On 5/24/2018 8:47 AM, Lance1578 wrote:
I guest no one knows the answer or you don't want to share your idea I really appreciate any help. |
| |
| |
| | | |
|
| | | | |
| | |
|