+ Start a Discussion
Kimberly Dy 16Kimberly 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.