community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Convert Separate Year, Month, Day Fields into YYYY:MM:DD format for In-DB

Highlighted
Atom

Hi all,

 

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.

Alteryx Partner

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 :)

Atom

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.

Alteryx Partner

What database are you using ?  That would determine the syntax that needs to be used.

Labels