Creating A Date Field

Hi Domo Community,

How would I go about creating a usable date field from two columns I have? One column is the year, and the other is the month. How could I create a date field from those two columns? For example, 2/1/2024 from a column that has February and a column that has 2024.

Thanks!

IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU! 😎😎😎

Best Answer

  • MichelleH
    MichelleH Coach
    Answer ✓

    @pauljames You can do this by concatenating the month and year into a date format, then using the STR_TO_DATE function to convert it into a date field.

    STR_TO_DATE(CONCAT(`Month`,' 1, ',`Year`),'%M %d, %Y')
    

Answers

  • MichelleH
    MichelleH Coach
    Answer ✓

    @pauljames You can do this by concatenating the month and year into a date format, then using the STR_TO_DATE function to convert it into a date field.

    STR_TO_DATE(CONCAT(`Month`,' 1, ',`Year`),'%M %d, %Y')
    

  • Similarly, you can do:

    DATE(CONCAT(`Month`,'/1/',`Year`))

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • pauljames
    pauljames Contributor

    @MichelleH thank you!

    IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU! 😎😎😎