This content has been marked as final. Show 2 replies
Hi Guys [CPC 20 Error Name]
Hi Guysif(sum(today()-[Date the Error was discovered])= '20',upper([Customer Name])) as
[CPC 20 Error Name]
As a work around for an Alert - I need to create a field made up of specific customer names.
I am trying to take the date an error was discovered and count how many days it is open ( By minusing it from todays date !!) if this is equal to 20 then creating a field called
[CPC 20 Error Name] that contains the names that was in Customer name,
I keep getting a syntax error on load , I think its how I have written the sum formula -- Can anyone please help ?