Date and time Parse tool

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.

Parse

Accepted answers

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

All comments

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

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

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.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703