Workbooks: is it possible to change the default format from MM,DD,YY

[former_member263899]

Hi

On the Enterprise Work Book it appears the default date format for uploads is set to American MM,DD,YY - can this be changed somehow for other date formats? If so how?

Thanks

John

[Former Member]

Hi,

In the Companies tab of Workbook, there is a field named DATE_FORMAT. There are a few options in this:

DATE_FORMAT_1 | DATE_FORMAT_10 | DATE_FORMAT_2 | DATE_FORMAT_11 | DATE_FORMAT_3 | DATE_FORMAT_12 | DATE_FORMAT_4 | DATE_FORMAT_13 | DATE_FORMAT_5 | DATE_FORMAT_14 | DATE_FORMAT_6 | DATE_FORMAT_15 | DATE_FORMAT_7 | DATE_FORMAT_8 | DATE_FORMAT_9

This corresponds to the following date formats:

DATE_FORMAT_10 MM/DD/YYYY HH:MM am/pm

DATE_FORMAT_2 Mon/DD/YY HH:MM am/pm

DATE_FORMAT_11 Mon/DD/YYYY HH:MM am/pm

DATE_FORMAT_3 DD-MM-YY HH:MM (24 hour clock)

DATE_FORMAT_12 DD-MM-YYYY HH:MM (24 hour clock)

DATE_FORMAT_4 DD-Mon-YY HH:MM (24 hour clock)

DATE_FORMAT_13 DD-Mon-YYYY HH:MM (24 hour clock)

DATE_FORMAT_5 DD.MM.YY HH.MM (24 hour clock)

DATE_FORMAT_14 DD.MM.YYYY HH.MM (24 hour clock)

DATE_FORMAT_6 DD.Mon.YY HH.MM (24 hour clock)

DATE_FORMAT_15 DD.Mon.YYYY HH.MM (24 hour clock)

DATE_FORMAT_7 YYYY/MM/DD HHMM (24 hour clock)

DATE_FORMAT_8 YYYY/Mon/DD HHMM (24 hour clock)

DATE_FORMAT_9 DD/MM/YYYY HH:MM (24 hour clock)

Based on your requirement, you can choose the value in the Workbook to be DATE_FORMAT_3 or DATE_FORMAT_12. Then when you load the Workbook, the date format will default to how you want to see it.

Also, this can be achieved by going into Setup > Company List > Your Company > Company tab and scrolling down to the Default Date Format field on the UI.

Hope this helps,

Vikram

[former_member263899]

Thanks, this explains nicely how to chnage the date format the companies workbook.

Is it possible to also change the date format throughout the enterprise workbook? From what I can see, as the enterprise workbook upload precedes the company workbook upload, there is no option to change the default data forma in the enterprise workbook?.

[Former Member]

There is a companies tab available in Enterprise workbook too (11th from the end in Version 5.1)

Vikram

[former_member263899]

Hi,

I can see tha you can specify the default date format for a company.

However, if you are uploading the enterprise workbook for the first time, no company exisits yet, therefore for things like Calendar Reporting Periods etc (which are tabs before the company tab). it looks like we should remember to use MM.DD.YY format as there is no place to change this format?

Thanks

[Former Member]

All of this is still configurable even AFTER the workbooks are uploaded. You can make the changes directly on the UI. Nothing is written in stone.

[Former Member]

Hi

There is a system property system.importer.csv.date_format wherein you can specify the date format string used when importing date values during csv import.

Regards

Mudit Saini

[Former Member]

Hi

You can also fire the SQL update query in your database for updating all of the Date format at a go . This can be done after your workbook is loaded and you want to change all date formats to other .

Regards

Sudipta