Method:Classic General Q&A

Re: Integration Tools - Import/Export - Date Field - Why Current Format?

furrywombat — Thu, 12 Nov 2015 15:58:25 GMT

Awesome, thanks!

Re: Integration Tools - Import/Export - Date Field - Why Current Format?

Method_Ben — Thu, 12 Nov 2015 15:53:42 GMT

Hi FW,

I noticed that Audisho has already put in a feature request for this one back in May. Ill make a note on the Request that you are asking about this one again.

Cheers,

Ben

Re: Integration Tools - Import/Export - Date Field - Why Current Format?

furrywombat — Thu, 12 Nov 2015 15:42:58 GMT

Thanks, Ben. This is specifically a request as it relates to the integration tools import/export. So that wouldn't work in this case. I did notice that it is exported correctly when inserted in a grid, however.

Re: Integration Tools - Import/Export - Date Field - Why Current Format?

Method_Ben — Thu, 12 Nov 2015 15:20:44 GMT

Hi FW,

Sorry for the late response. Ill have to look in to why the date is formatted this way, as im not enitrely sure why this is the case. As a workaround though, you could try adding the data you are trying to export to a Grid, format the Date in the grid column directly, and Export it that way.

Regards,

Ben

Integration Tools - Import/Export - Date Field - Why Current Format?

furrywombat — Thu, 05 Nov 2015 18:27:37 GMT

Why do date fields export as 2015-Nov-04 12:00:00 PM as opposed to something usable/sortable, i.e. 2015-11-04 12:00:00? Every time I export data using the integration import/export tool I need to run through the fields replacing Jan/Feb/Mar/etc with 01/02/03/etc and eliminating the AM/PM portion of the time entry. But when I grab these fields via API query, it returns usable datetime format. Is there some reason that I am missing why the system is setup this way currently?