1. TARGIT Community
  2. Community
  3. Feature requests / Ideas
Knowledge Base

Format options for dynamic content (date/time)

Søren Sørensen ·

I'm in Australia and would like to see the current date formatted as d/mm/yyyy but when I use the Current Date system variable (dynamic content in text boxes), I get the American format m/dd/yyyy.

I can't find any setting on the server that's not saying Australia so in the absence of knowing where to change the server setting (or whatever the setting is), it would be nice with a format feature when we select dates (and times) for dynamic system content (dynamic cube content is of course handled by the cubes).

Alternatively, we could have either a global entry in the Settings.xml file or an entry in each user's Preferences.xml file that tells how to format system dates (and times), including the Dynamic Date Origin selector (which does come through in the Australian format so that's apparently following the server setting).

4

Comments

6 comments
Sort by DateVotes
  • Steen Gøbel

    Hi Søren 

    I was having the same challenge as you, but found this reason from Ole on the community.

    Change date format – TARGIT Community

    My Targit client language was "English (Worldwide)" and therefore get mm/dd/yyyy, but changing to "Danish" gives me dd/mm/yyy.

    0
  • Søren Sørensen

    Hi Steen,

    That's interesting!

    Based on your family name, I think you're Danish. I'm Danish too but I live in Sydney and serve the Australian market ... not sure if my customers will be happy if I change the client language :-) ... so I guess the solution is to request a British or Australian version of English to be added to our language portfolio.

    Thanks for the brilliant info ... have a lovely weekend!

     

    0
  • Steen Gøbel

    I agree with you on that one, since US is the only place in the world that uses mm/dd/yyyy, there should be an "English (Worldwide)" with dd/mm/yyy and a "English (US)"  with dd/mm/yyyy.

    1
  • Marc Hoeller

    Hi, I have the same Problem by using Parameters in Jobs.

    If I choose actual Data, I get a format like "20250115" yyyymmdd which is not nice when using it in Job E-mail Headers.

     

    0
  • Søren Sørensen

    Circling back to this one ... will AI help us getting English date formats right outside the US?
    :-)

    0
  • Ole Dyring

    Hi Everyone,

    With the latest release, the 2025 June release (cloud and on-prem) we have included UK English in the list of supported languages. This should take care of the issue with showing dates for e.g., dynamic content in the US English format.

    See this article: https://community.targit.com/hc/en-us/articles/9803299658140-Client-language 

    BR / Ole

    0
Please sign in to leave a comment.