You need to sign in to do that
Don't have an account?
Help with CreateDate in Formula
Hi,
I have a formula that makes a field required if certain requirements are met. I found out that it is effecting older cases where this new field wasn't active yet.
How do I put a qualifier on the formula so that it only applies to cases created after 6/30/2103?
My formula is
AND(ISPICKVAL( Product_Category__c , "Defense Technology"), TEXT(Order_Contains_ATF_Items__c)="") && $RecordType.Name = "Customer Care" && ISPICKVAL(Case_Type__c , "Place an Order") && ISPICKVAL(Status, "Closed")&& CreateDate < 2013-06-30T00:00:00.000Z
My error message states Error: Syntax error. Extra T00:00:00.000Z
Thanks. :)
CreatedDate < DATETIMEVALUE( DATE(2013, 6, 30))
All Answers
CreateDate < DATE(2013, 6, 30)
Thanks. I tried it but I get an error message that states
Error: incorrect parameter type for operator '<' Expected DateTime, received Date.
Did you mean to use CreatedDate instead of CreateDate? CreatedDate is a date/time field. If not, use DATETIMEVALUE() to convert a date type to a date/time.
I used CreateDate first but then it said there was no such field.
I used CreatedDate in my original formula post - what would I do different to not get the posted error?
CreatedDate < DATETIMEVALUE( DATE(2013, 6, 30))
Thank you so much - it worked! :)