Formula Help Required

[vishwa1979]

Dear Team,

I have a sample data.

In that I want to check whether Issuance Date is between Period Between.

I tried using text to column but not getting requirement result.

Please help

[Felipe_Ribeir0 · Accepted solution]

Hi @vishwa1979 

Check the attached workflow

[Jonathan-Sherman]

If you wanted you could even do it just in the one tool! (love a one tool solution 😎)

[DataNath]

One of the new features for 2023.1 was the Between() function so you could even use that with some regular string functions as well if you're using that!

IIF(Between(DateTimeParse([Issuance Date],'%d-%b-%Y'), DateTimeParse(Left([Period Between], 10),'%d.%m.%Y'), DateTimeParse(Right([Period Between], 10),'%d.%m.%Y')),'Between','Not between')