CSV Data Converting to Date

I have a CSV file with different types of data; Unit # Resident Name, and Lease Dates. The Unit # is converting from # to Date and I can't seem to resolve it. I converted my excels to CSV; that did not work. Not all unit #s are converting to a month and/or month and day. The results window shows the data correctly; but the output file is displaying the below. Jun-35 should read 6-35 etc

Unit # Primary Name Lease Begin Date
Jun-35 Shaina Olds Seymour 9/11/2024
Jun-36 Eric Callen 5/15/2024
Nov-37 Mary Thomas 7/1/2024
Nov-38 Kimberly Rossetti 12/21/2023
Nov-46 Tasha Luke 2/29/2024
Nov-47 Rick Charroud 7/14/2024
Nov-48 Ben Kaboyi 10/1/2024
15-49 Maria Ellis 9/1/2024
15-50 Bassel Bittar 9/27/2024
15-51 Richard Roark 12/15/2023

Workflow

Designer Cloud

Regex

Dynamic Processing

Accepted answers

Yoshiro_Fujimori

Just as a sample, if your expected values are as below;

Input	Expected
Jun-35	06-35
Jun-36	06-36
Nov-37	11-37
Nov-38	11-38
Nov-46	11-46
Nov-47	11-47
Nov-48	11-48

You can convert it with Date Time functions as below:

Workflow

Expression

Expected =

If IsInteger([1]) THEN [1]

ELSE DateTimeFormat(DateTimeParse([1],"%b"),"%m")

ENDIF

+ "-" + [2]

workflow.yxmd

All comments

Yoshiro_Fujimori

Hi @sslattery17

I guess the conversion occurs at Excel , not at Alteryx.

If this is the case, you may want to try this tips:

https://support.microsoft.com/en-us/office/stop-automatically-changing-numbers-to-dates-452bd2db-cc96-47d1-81e4-72cec11c4ed8#:~:text=Preformat%20the%20cells%20you%20want,before%20you%20enter%20a%20number.

I hope it helps.

sslattery17

@Yoshiro_Fujimori Thank you.

We receive a lot of excel or csv files from clients, I would say over a 2000 a month. In excel this is simple by converting the column to text; but I have not found a way to do this in Alteryx. Once I complete my workflows; I load them in a system to analyze the data; if I add an ' before as one of the recommendations; I then have to open all the output files to remove the ' before loading them. That is 2 different times I have to touch the spreadsheet before processing my workflow.