PricingBlog

publish

  • c1yde_michael_92537-1224411220183089205

    clyde_michael

    1 year ago

    Hello. I'm hoping someone will be able to help me format the output from the Now() function like this: YYYY-MM-DD. I've asked the AI to help and it said the options should be as follows: year:numeric,month:2-digit,day:2-digit. Unfortunately, the resulting date is still in the format MM-DD-YYYY. My locale is set to en-US. Many thanks.
  • kamilnader-1224431384387387462

    Kamil

    1 year ago

    Try locale: en-CA without any options
  • c1yde_michael_92537-1224447564464656605

    clyde_michael

    1 year ago

    Thanks Kamil! That worked like a charm. And to add insult to injury, I actually live in Canada!
    👍1
    😀1
  • kamilnader-1224595267672604763

    Kamil

    1 year ago

    I struggle with this one as well, trying to create some custom formula, but in the end, this is the simplest solution👍