Issue with Date Format in Document Generation: Converts to US Format

This discussion was created from comments split from: Date Format in forms.

Answers

  • Hi,

    I am in AU. I experience this same issue. The sheet has the correct date. However, when "generating a document", the date entered into the Doc is in American format. I raised a ticket through support, but I got a very unhelpful response, noting that behavior is "expected", as an "automation" or "doc generator" is done in the backend in the US, rather than by the user. As such, cannot be fixed.

    I was almost given a workaround, through extracting the date with a formula (not really helpful):

    "Thank you for your patience. The only thing I was able to discover is a formula that could work by pulling the date value and converts it to text, however it doesnt pull over the month. You may be able to explore this and look into the community posts to find a way to expand on this formula.

    =LEFT("0", 2 - LEN(DAY(Date1))) + DAY(Date1) + " " + LEFT("0", 2 - LEN(MONTH(Date1))) + MONTH(Date1) + " " + YEAR(Date1)

    For example, this will turn 01/01/24 into 01 01 2024"

    The month function is a little more complex but could be searched for in the community section.

    In the meantime you could manually enter the dates in the text column labeled Date so that it pulls over to the Generated PDF's properly."

    Does anyone else have the same issue and found a fix?

  • SSFeatures
    SSFeatures ✭✭✭✭✭

    Hi Daniel,

    If you do not configure the date's format then it will automatically use the regional format, which will default to the US because SmartSheet generates the PDF on US servers.

    However, what if you manually configure the date's format into a different format?

    Then if you generate the document, it should use the format that you explicitly chose.

    Let me know if this works for you.

    Best!

    SSFeatures - The browser extension that adds more features into SmartSheet.

    • Automatic sorting, sorting with filters, saving sort settings
    • Spell checking
    • Report PDF generator that supports grouped and summarized reports