How to write first day of current year in Beast Mode

I'm trying to write a query but stuck at beast mode. Can anyone help me with writing 'First day of the current year' in beast mode?

Thank you.

Comments

  • AS
    AS πŸ”΅

    This is one way to do that:

    str_to_date(concat(year(curdate()),'-01-01'),'%Y-%m-%d')

    Aaron
    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"