This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am looking to convert separate Year, Month, and Day fields into a YYYY:MM:DD format In-DB.
I'm looking to gather data for the most recent 3 months of a specific dataset as of today. Converting to the above date format would help set the proper parameters.
I look forward to your thoughts and advice on how to do this as I am still getting up to speed on Alteryx.
I would use a Formula in-DB tool to create a new field with Date datatype.
The SQL expression would depend on your exact database, but it should be possible :)
Thanks, @cmcclellan. That was my initial thought on creating a separate Date field using the formula, but wasn't sure.
I don't know how to write the SQL expression for my dataset so that is where I am getting stuck.
What database are you using ? That would determine the syntax that needs to be used.