Home
Events
Groups
Members

01 Watercooler
02 Bugs
02 Starting with Clay
Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
Gtm Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Powered by Tightknit

Error in Formula for Funding Date Between Two Dates | Clay

Error in Formula for Funding Date Between Two Dates

·

·

I am getting an error while using this formula. This is my text for the formula: "If "Funding date column" is between January 1, 2024 and February 15, 2025 THEN Return Y" Formula Generated : moment({{Funding Date}}).isBetween("2024-01-01", "2025-02-15", undefined, "[]") ? "Y" : "" What is the issue here?

Loading attachments

8 comments

· Sorted by Oldest

Channeled
APP
·
·
Try refreshing your browser using Cmd/Ctrl + Shift + R to resolve the "Error evaluating formula" issue in your output column. If the error persists after refreshing, please request human support to help troubleshoot the specific formula syntax, as they can better analyze the exact error you're encountering with the moment.js implementation.
Channeled
APP
·
·
Is that what you were looking for?
Channeled
APP
·
·
Great! Let me know if you have more questions.
Sahil S.
·
·
It got solved. I tweaked the formula for a date greater than version
Channeled
APP
·
·
Hi Sahil S.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Sahil S.!
Channeled
APP
·
·
Glad to hear you found a solution! Let me know if you need anything else.
Channeled
APP
·
·
Thank you so much for sharing your feedback Sahil S.!