PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEVWEBDEV e WINDEV Mobile

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) // 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






--
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.