General Caster formula to detect change between creation and updated dates

monday Apps & Developers
, ,
1

Hi,
I am trying to use general caster to detect if there is a change between creation and updated dates.

The following doesn’t seem to work:
IF({item’s Created Time}<> {item’s Updated Time}, “Different”, “Same”)

Let me know the correct formula to use.

Thank you

2

Hello @Syam and welcome to the community!

I hope you like it here :muscle:

I think this question will be best answered by @rob :grin:

Cheers,
Matias

1 Like
3

Hey @Syam
Please replace <> with != and let me know if it works.

4

Thanks Rob, Matias.

It did not work unfortunately.

My automation recipe is:
If any column changes, perform formula and cast result to Status

where formula is IF({item’s Created Time} != {item’s Updated Time}, “Yes”, “No”)

BTW, I have been using free version of Caster.

Thank you

6

What do you mean it doesn’t work?
Do you get any errors or simply you don’t see the result in the destination column?
In the formula I see you use diagonal quotes, please make sure to use straight quotes (").

7

Hi Rob,
Thank you. The issue is — result is not written to the destination status column.

Thanks

8

Please contact us at help@generalcaster.app reporting the URL of your monday account.