Export Data from Grid list to Excel, time/date stamp on excel

Hello,

I am exporting from the Purchase Order Entry, in Kinetic. I export the grid to an excel file, and the dates came out as XX/XX/XXXX.

Fast forward to today. The dates come out as 2014-04-16T00:00:00.

I can not figure out for the life of me how this is happening, I export out of pilot and get the XX/XX/XXXX format. Others export out of their profiles and get that format too.

How do I get the XX/XX/XXXX back into my export? I’m trying to avoid having to to a txt to column step.

Hi @lbradbury ,

I think this will answer your question.
Go to Control Panel and the Region
There change the time format to whatever you want.
It will automatically change it as soon as you change the format and click on Apply button:

Thank you for the reply, unfortunately this didn’t solve the excel export out of epicor.

I just came across this. Format your cells to custom with the type as per the screen below. After that, you can reformat them into XX/XX/XXXX. Happy days.

image

Did you ever find a fix for the date/time? We are currently having this issue after an upgrade.

If you are looking at the function Convert - here’s a list of codes.

Example - Convert(varchar, 12/13/2019, 111) = 2019/12/13
DATE ONLY FORMATS
Format # Query Sample
1 select convert(varchar, getdate(), 1) 12/30/06
2 select convert(varchar, getdate(), 2) 06.12.30
3 select convert(varchar, getdate(), 3) 30/12/06
4 select convert(varchar, getdate(), 4) 30.12.06
5 select convert(varchar, getdate(), 5) 30-12-06
6 select convert(varchar, getdate(), 6) 30 Dec 06
7 select convert(varchar, getdate(), 7) Dec 30, 06
10 select convert(varchar, getdate(), 10) 12-30-06
11 select convert(varchar, getdate(), 11) 06/12/30
12 select convert(varchar, getdate(), 12) 061230
23 select convert(varchar, getdate(), 23) 2006-12-30
101 select convert(varchar, getdate(), 101) 12/30/2006
102 select convert(varchar, getdate(), 102) 2006.12.30
103 select convert(varchar, getdate(), 103) 30/12/2006
104 select convert(varchar, getdate(), 104) 30.12.2006
105 select convert(varchar, getdate(), 105) 30-12-2006
106 select convert(varchar, getdate(), 106) 30 Dec 2006
107 select convert(varchar, getdate(), 107) Dec 30, 2006
110 select convert(varchar, getdate(), 110) 12-30-2006
111 select convert(varchar, getdate(), 111) 2006/12/30
112 select convert(varchar, getdate(), 112) 20061230

1 Like