Convert MM/DD/YYY (String) to Date Format - In DB

[yvonnemiao]

Hi,

I am trying to figure out a way to convert the string to date using in DB formulas/ tools.

The date is stored as MM/DD/YYYY as V_String in the database, and I would like to convert it to date format before stream the dataset out of database.

From In DB as a string:

Thank you!

[caltang]

Use 

CAST("Funded Date" AS DATE)

[nagakavyasri]

@yvonnemiao Can use anyone of below:

[Raj]

To convert the date format from MM/DD/YYYY to a date format in Alteryx, you can use the "DateTimeParse" function. Here are the steps:

1. Drag and drop a "DateTimeParse" tool onto your workflow canvas.

2. Connect the tool to your data source.

3. In the "DateTimeParse" configuration pane, select the column that contains the date in the V_String format.

4. Under "Input Format," select "Custom."

5. In the "Input Format String" field, enter "MM/dd/yyyy" to match the format of the V_String date.

6. Under "Output Format," select the desired output format for the date.

7. Click the "Run" button to execute the workflow and convert the date format.

Once you've completed these steps, the date column in your dataset will be in the desired date format. You can then proceed to stream the dataset out of the database with the updated date format.

[apathetichell]

Formula In-DB varies based upon what DB you are using (ie what kind of database you are using dictates the syntax of the SQL (SQL-esque) function)... What DB are you using?

[ArtApa]

@yvonnemiao - There was a very similar question recently. Please have a look: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-convert-string-date-YYY...