PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → 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
Débuté par Lance1578, 08 mai 2018 05:18 - 2 réponses
Membre enregistré
1 message
Posté le 08 mai 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) // 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
Posté le 24 mai 2018 - 16:47
I guest no one knows the answer or you don't want to share your idea :-(
I really appreciate any help.
Posté le 24 mai 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.