Comparing Date field to constant to assign value

[hmsmorgan]

Hello--

I'm trying to create a formula that would populate a field based on when an application was submitted. For example, if submitted between Aug 1 and Dec 1, then the field value would be 'Cycle 1'

I was thinking I could use a formula, but I', not getting it to work how I imagine...

CASE
WHEN [@field:Date_Created_in_Caspio]  >= '01/08/2020' AND <= '01/12/2020'
THEN 'Cycle 1'
END

Thanks for any help!

 

[CoopperBackpack]

Hello @hmsmorgan,

If you use this statement in the Formula field in the table, please try this formula:

CASE
WHEN  [@field:Date_Created_in_Caspio] BETWEEN CONVERT(datetime, '01/08/2020', 101) AND CONVERT(datetime, '01/12/2020', 101)
THEN 'Cycle 1'
END

 

This should work if the  [@field:Date_Created_in_Caspio] field has Date/Time or Timestamp DataType.

Please note that the BETWEEN operator is inclusive: begin and end values are included.

Hope this helps.