Skip to main content
Solved

Dates are not recognized in spanish

  • March 31, 2021
  • 3 replies
  • 20 views
J
Forum|alt.badge.img+5

I am using DATETIME_PARSE, but it has problems with some months in spanish, as you can see in the screenshot.
I am trying to convert those months, but I cant get the way.
Any ideas ??

Best answer by Justin_Barrett

A collection of nested SUBSTITUTE() functions should do the job to replace the Spanish abbreviations with their English equivalents (this sample only swaps a few; add more nested functions to cover any missing months with spelling variations):

SUBSTITUTE(
  SUBSTITUTE(
    SUBSTITUTE(
      {Fecha Vencimiento}, "ABR", "APR"
    ), "DIC", "DEC"
  ), "AGO", "AUG"
)

Wrap that inside a DATETIME_PARSE() function:

DATETIME_PARSE(
  SUBSTITUTE(
    SUBSTITUTE(
      SUBSTITUTE(
        {Fecha Vencimiento}, "ABR", "APR"
      ), "DIC", "DEC"
    ), "AGO", "AUG"
  ), "DD-MMM-YYYY"
)

    3 replies

    Justin_Barrett
    Forum|alt.badge.img+21

    A collection of nested SUBSTITUTE() functions should do the job to replace the Spanish abbreviations with their English equivalents (this sample only swaps a few; add more nested functions to cover any missing months with spelling variations):

    SUBSTITUTE(
  SUBSTITUTE(
    SUBSTITUTE(
      {Fecha Vencimiento}, "ABR", "APR"
    ), "DIC", "DEC"
  ), "AGO", "AUG"
)

    Wrap that inside a DATETIME_PARSE() function:

    DATETIME_PARSE(
  SUBSTITUTE(
    SUBSTITUTE(
      SUBSTITUTE(
        {Fecha Vencimiento}, "ABR", "APR"
      ), "DIC", "DEC"
    ), "AGO", "AUG"
  ), "DD-MMM-YYYY"
)

    J
    J
    Forum|alt.badge.img+5
    • Jose_Munoz
    • Author
    • Participating Frequently
    • April 9, 2021

    A collection of nested SUBSTITUTE() functions should do the job to replace the Spanish abbreviations with their English equivalents (this sample only swaps a few; add more nested functions to cover any missing months with spelling variations):

    SUBSTITUTE(
  SUBSTITUTE(
    SUBSTITUTE(
      {Fecha Vencimiento}, "ABR", "APR"
    ), "DIC", "DEC"
  ), "AGO", "AUG"
)

    Wrap that inside a DATETIME_PARSE() function:

    DATETIME_PARSE(
  SUBSTITUTE(
    SUBSTITUTE(
      SUBSTITUTE(
        {Fecha Vencimiento}, "ABR", "APR"
      ), "DIC", "DEC"
    ), "AGO", "AUG"
  ), "DD-MMM-YYYY"
)


    Thanks Justin, it works perfectly !!

    Justin_Barrett
    Justin_Barrett
    Forum|alt.badge.img+21

    Glad to know that you got the answer you were seeking! If you would, please mark my comment (the one above, not this one) as the solution to your question. This helps others who may be searching with similar questions. Thanks!

    Terms & ConditionsAccessibility statement