STR to Date

Options
ColinHaze
ColinHaze Member
in Magic ETL

Hi,

I have a ETL formula tile That I am passing a str through and turning it into a date using this formula STR_TO_DATE(Get Fiscal Months, '%Y-%m-%d') however its coming out as NOV 1st 2023 12:00am. Is there a way to get rid of the 12 AM?

Thanks in advance!

Best Answer

  • jessdoe
    jessdoe Contributor
    Answer ✓
    Options

    You can wrap your existing formula in the date function. Date(str_to_date())

Answers

  • jessdoe
    jessdoe Contributor
    Answer ✓
    Options

    You can wrap your existing formula in the date function. Date(str_to_date())

Categories