If Today is between 2 dates formula issue
Hi all,
I'm trying to work out if today is between two date fields on a record but I cant for the life of me work it out.
I've been trying to get this to work but if anyone can tell me where I'm going wrong i'd be really grateful!
IF(AND(${Deals.Deal Start Date}<=Now()),(${Deals.Deal End Date}>=Now()),'In Delivery','Not In Delivery')
the start date and end date fields are both date fields in crm and ive set formula return tyoe to string but i just keep getting 'Syntax Error for given formula'
Any ideas?