Skip to Content

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 27, 2012 at 07:10 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.