How to look for > or < Date strings

[wonka1234]

Hi,

I am trying to look for greater or less then a date, however my date fields are strings as it is read in from an excel file i do not control

How can I do this? 

My current formula is like this, but i dont think it looks for between the dates i look for.

IF
([Date1] > '01-Nov-22') AND ([Date2] < '31-Dec-23')

[DataNath · Accepted solution]

@wonka1234 to work with dates, you'll need them to be in ISO format (YYYY-MM-DD). To get that from your current date, you'll need to parse it from your string, telling Alteryx the incoming format like so:

%d represents day

%b represents abbreviated month

%y represents a 2-digit year

[ScottE]

Hi @wonka1234 ,

You can use the Date Time Parse tool to convert your strings to date types.

https://help.alteryx.com/20223/designer/datetime-tool

Once converted you should be able to use a filter set up the date range you're looking for.

Hope that helps,

Scott