Date and time Parse tool

[ssakshi2]

Hi Team,

We are trying to identify latest date from filename using DateTime parse tool by first importing all file name.

I am converting from String to Date/Time format

For Example, file name is 'Breakdown for analysis-20241025.csv'

I am putting below under 'Specify the format of the incoming string field' 

'Breakdown Report for analysis - %Y%m%d.csv'

But the Example box shows '''Break2own Report 0or analysis - 20241025.csv'

Question: Why Alteryx is reading 'd' as '2' and 'f' as '0'?

Attached is the screen shot of the Date Time Parse tool configuration.

[Raj]

@ssakshi2 
add the sample data will be in better place to help.

[binuacs · Accepted solution]

@ssakshi2 If you are looking for extracting date you can try something like below

[Raj]

@ssakshi2 

It looks like Alteryx is interpreting characters in your date format specifier as placeholders rather than as literal text due to a minor formatting issue.

In the DateTime Parse tool, any literal text in your date format string (such as “Breakdown for analysis - ”) should be enclosed within single quotes (' ') so that Alteryx doesn’t misinterpret letters as format codes. Your updated format string should look like this:

'Breakdown for analysis - '%Y%m%d'.csv'

hope this helps.