|
| 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, 08,may. 2018 05:18 - 2 respuestas |
| |
| | | |
|
| |
Miembro registrado
1 mensaje |
|
Publicado el 08,mayo 2018 - 05:18 |
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 el 24,mayo 2018 - 16:47 |
I guest no one knows the answer or you don't want to share your idea 
I really appreciate any help. |
| |
| |
| | | |
|
| | |
| |
Publicado el 24,mayo 2018 - 19:32 |
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. |
| |
| |
| | | |
|
| | | | |
| | |
|