Using a file for dynamic input

[miguelboi23]

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.

[binu_acs]

@miguelboi23 Can you upload your input files as well?

[miguelboi23]

Attached. Thank you. 

[ScottE · Accepted solution]

Hi @miguelboi23 

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 

[binu_acs · Accepted solution]

@ScottE One way of doing this

[miguelboi23]

Awesome. Crystal clear. Thanks so much for your assistance and input!