Skip to main content

General Caster formula to detect change between creation and updated dates

  • July 9, 2023
  • 6 replies
  • 351 views

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

6 replies

Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • July 9, 2023

Hello @Syam and welcome to the community!

I hope you like it here 💪

I think this question will be best answered by @rob 😁

Cheers,
Matias


rob
Forum|alt.badge.img
  • monday.com Partner
  • July 10, 2023

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


  • Author
  • New Participant
  • July 10, 2023

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


rob
Forum|alt.badge.img
  • monday.com Partner
  • July 12, 2023

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 (").


  • Author
  • New Participant
  • July 12, 2023

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

Thanks


rob
Forum|alt.badge.img
  • monday.com Partner
  • July 12, 2023

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