Using a file for dynamic input

Hello,

New here and need some help. I am trying to query records in the DATA file by the date that I manually set in the DATE file.

In the DATA file, the dates are formatted like "10-FEB-2022"

In the DATE file, the date is formatted like "02/10/2022"

I can't seem to get them connected. I tried formatting the dates the same and it still doesn't work.

Accepted answers

You can use the Date Time Parse tool to convert your strings to dates and then I'd append your conditions.

The attached will solve for the inputs you provided and you can probably use an IF/THEN statement if you have a more complicated set of conditions.

Hope that helps,

Scott

@ScottE One way of doing this

@miguelboi23 Can you upload your input files as well?

Attached. Thank you.

You can use the Date Time Parse tool to convert your strings to dates and then I'd append your conditions.

The attached will solve for the inputs you provided and you can probably use an IF/THEN statement if you have a more complicated set of conditions.

Hope that helps,

Scott

@ScottE One way of doing this