Euro Formatted Date Fields

An Australian QuickBase customer asked today, “How can we change the 01-20-2010 (U.S. date format) to the Euro 20-01-2010 format?”. They want their reports to display in a format that is customary for their country and locale. Well you can if you add a formula text field and reformat the date.

See Video

There is also a really good QuickBase Knowledgebase article you can reference.

By the way we hold 10 live webinars each week. Many explore customization ideas like this one.
Register here.

Kirk Trachy

QuickBase evangelist, sales engineer and lover of all things possible with QuickBase. Check out Kirk live at one of his daily webinars.

More Posts - Website

  • Pingback: IntuitQuickBase at 01/20/10 05:45:10 | Exectweets

  • Hunter

    We get requests for an non-US date input format all of the time.

    That being said, it is definitely helpful that QB displays the date using the three letter month as you enter it. Also beneficial is the fact that you can enter a date as mmm-dd-yy.

    Thanks!

    [Reply]

  • Hunter

    We get requests for an non-US date input format all of the time.

    That being said, it is definitely helpful that QB displays the date using the three letter month as you enter it. Also beneficial is the fact that you can enter a date as mmm-dd-yy.

    Thanks!

    [Reply]

  • http://www.ceva.com/ Francois Tricot

    Generally speaking, it would be nice to have much better compatibility with other countries standards. Date fields should be displayed in the user local format. We use Quickabse for users all other the world and Dates are always a problem, as well as dots and commas for Numeric field which are used differently in Europe for instance, Phone fields, only usefull for USA, and currencies in graphs that always come as $, whatever you enter as a currency symbol.

    [Reply]

  • http://www.ceva.com Francois Tricot

    Generally speaking, it would be nice to have much better compatibility with other countries standards. Date fields should be displayed in the user local format. We use Quickabse for users all other the world and Dates are always a problem, as well as dots and commas for Numeric field which are used differently in Europe for instance, Phone fields, only usefull for USA, and currencies in graphs that always come as $, whatever you enter as a currency symbol.

    [Reply]

  • http://intuit.quickbase.com/ Kirk Trachy

    Francois: You are so right. I have forwarded your comments to our Product Manager. Kirk

    [Reply]

  • http://intuit.quickbase.com Kirk Trachy

    Francois: You are so right. I have forwarded your comments to our Product Manager. Kirk

    [Reply]

  • http://www.naturevet.com.au/ Sal Terranova

    Quickbase needs to get with the rest of the world in sync.
    Its so frustrating using a good tool and then having something so basic as dates, in USA format.
    Every other country in the world basically uses non USA dates.
    Fast track this mod please!!!!

    [Reply]

    Kirk Trachy Reply:

    @Sal Terranova, Thank you for you comment. I shared your comment with our Product Manager team. Best, Kirk

    [Reply]

  • http://www.naturevet.com.au Sal Terranova

    Quickbase needs to get with the rest of the world in sync.
    Its so frustrating using a good tool and then having something so basic as dates, in USA format.
    Every other country in the world basically uses non USA dates.
    Fast track this mod please!!!!

    [Reply]

    Kirk Trachy Reply:

    @Sal Terranova, Thank you for you comment. I shared your comment with our Product Manager team. Best, Kirk

    [Reply]

  • Ramon

    Hello Francois.

    We are based in Europe and have been using quickbase since 2003 mainly with our offices and users across Europe. I have asked Quickbase many times in the last 6 years for country & language customizations but not result so far. They say they are not even on the roadmap.

    Let´s hope this changes in the near future as even if 98 % of Quickbase clients are supposed to be in the US, this customers DO have users worldwide so Quickbase should do something for them…….and as a consequence for us based outside the US.

    Regards. Ramón

    [Reply]

  • http://www.tiffanyforsale.com tiffany sale

    With MCF Office you can integrate your Microsoft Office documents with QuickBase. Emails from Outlook and documents from Word, Excel and PowerPoint. As you edit a document you select a project or contact you want to save to and MCF Office saves it to your QuickBase.

    [Reply]

  • http://www.discountiffany.com tiffany jewellery

    Team members know clearly when the team has experienced success and share the joy in such excellence proudly.

    [Reply]

  • Ton Jense

    This is not a solution. This is a workaround.
    I have tables with 20+ datefields. Creating a dummy textfield for each and every datafield in the database is a lot of work, it could easily couse errors and instructing users to choose the right fields in reports is unneccessary if Intuit would finally implement local dates and amounts. I’ve been asking for this for over three years now and in my opnion it should not be such a big problem to fix it….

    [Reply]