Apex Code Development You need to sign in to do that
Don't have an account?
Kimberly Dy 16 Workflow update error due to February leap year
I have a formula in the workflow that updates date and time (picklist field) into a date/time value. However, I am receiving the erorr "Computed an invalid date, such as February 29th on a non-leap year. Please contact your administrator; formula fields can cause such errors." Does anyone know how I can incorporate the leap year on my current formula?
DATETIMEVALUE(TEXT( AP_Meeting_Date__c ) + "" +
TEXT( VALUE( LEFT( TEXT(Meeting_Start__c),2)) + 7) +
MID(TEXT(Meeting_Start__c),3,3) + ":00")
Thank you in advance.
DATETIMEVALUE(TEXT( AP_Meeting_Date__c ) + "" +
TEXT( VALUE( LEFT( TEXT(Meeting_Start__c),2)) + 7) +
MID(TEXT(Meeting_Start__c),3,3) + ":00")
Thank you in advance.