Use Range in Date Field

[Catra]

How can I use Date range in CASE WHEN? Do you have samples? Thanks!

[Meekeee]

Hi @Catra - you can try this one:
 

CASE 
WHEN [@field:DATE_FIELD] >= CONVERT(datetime, 'mm/dd/yyy', 101) AND [@field:DATE_FIELD] <= CONVERT(datetime, 'mm/dd/yyy', 101)
THEN 'TRUE' 

ELSE 'FALSE'
END

For more information, you may check this article: 
https://howto.caspio.com/function-reference/

[Catra]

Thank you @Meekeee!

[TellMeWhy]

3 minutes ago, Catra said:

Thank you @Meekeee!

If you want it to precise to DATE without the time (cause sometimes it conflicts), you can just convert to date instead of datetime.