Timeline for Validation rule - created date < FIXED DATE
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 15, 2020 at 8:11 | history | edited | CommunityBot |
Commonmark migration
|
|
| Nov 20, 2018 at 15:47 | vote | accept | Devin Pearman | ||
| Nov 19, 2018 at 22:45 | history | edited | David Reed | CC BY-SA 4.0 |
added 175 characters in body
|
| Nov 19, 2018 at 22:44 | comment | added | Devin Pearman |
I'm not 100% on what you're meaning by converting to a DateTime, when this is all in a validation rule, there's got to be something I'm not understanding. I've tried adding a DATEVALUE but that doesn't seem to work either, perhaps I'm not using the correct syntax: ISPICKVAL ( StageName, "Negotiation")&& Clinical_Acceptance__c = FALSE&& CreatedDate < DATEVALUE("2018-10-31") The error I'm receiving: "Error: Incorrect parameter type for operator '<'. Expected DateTime, received Date"
|
|
| Nov 19, 2018 at 22:37 | comment | added | David Reed |
You can convert the DateTime to a Date with the DATEVALUE() function, too.
|
|
| Nov 19, 2018 at 22:30 | comment | added | Devin Pearman |
I've attempted to use the DATE() function, but still getting an error: Incorrect parameter type for operator '<'. Expected DateTime, received Date I had entered: CreatedDate < DATE(2018,10,1)
|
|
| Nov 19, 2018 at 21:47 | history | answered | David Reed | CC BY-SA 4.0 |