Jump to content

Export Table as CSV - Family Date Problems

Recommended Posts

I've got a client wanting a load file creating, and need to provide the other side (court ordered) a list of items arranged by date today (they told me last night), and they are having issues formatting the table using the family date.

It won't arrange by family date at all, and everything is being exported in american date format, which is no good to my client, they need the data to be British date/time format.

I'm having the same issues with the family date and no matter what I do, even exporting the text columns into a text file them importing them into excel they just don't want to change.
some dates are fine, i.e. they will format as dates, whereas others will not change at all, no matter what I do to them in excel.

Does anyone have any guidance at all?

Link to comment
Share on other sites

Hi Fuzed,

I just replied to your support ticket, where you posted the same problem. I did few tests on my own and I don't see any issues with the software, so I think it may be a problem with choosing the wrong settings. You can change date formats to any custom one. This is described in section "15.2.11. Load file options" if Connect User Manual. Sorting options are described in "15.2.17. Reports and ordering".

Hope you will be able to figure this one out!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...