Date to be between 2 date ranges

[pmohancos]

Discussed in https://github.com/great-expectations/great_expectations/discussions/4276

^{Originally posted by kyleaton February 25, 2022} Hello!

It will be great to have an expectation that checks a date column to be between 2 date ranges.

[Chr96er]

This should be possible using the expect_column_values_to_be_between expectation: https://greatexpectations.io/expectations/expect_column_values_to_be_between

You might have to set parse_strings_as_datetimes=True.

[nicholaskebut1]

This should be possible using the expect_column_values_to_be_between expectation: https://greatexpectations.io/expectations/expect_column_values_to_be_between

You might have to set parse_strings_as_datetimes=True.

I places parse_string_as_datetimes = True and it errors out. Is parse strings as date time deprecated or is it currently supported?

[pmohancos]

Same here, it is giving me an error message - could not convert string to float.

[nicholaskebut1]

Same here, it is giving me an error message - could not convert string to float.

Which version of great expectations are you using?

[pmohancos]

Sorry, for the late reply. I am using the version 0.18.3. I have written a custom expectation for this and is fulfilling my need now.