You need to sign in to do that
Don't have an account?
Rohit Ammanamanchi
Can anyone advise me what to do inn this case??
I have created a Customer-media object and I created the fields "Books checked out" and "return date". I want to calculate the "due date" of the formula type where it is supposed to be 14 days after the "book checked out". What is the formula used to this?
I have tried this formula
IF( Book_Checked_out__c , Book_Checked_out__c , Book_Checked_out__c() <> 15 ) and its throwing me an error.
I have tried this formula
IF( Book_Checked_out__c , Book_Checked_out__c , Book_Checked_out__c() <> 15 ) and its throwing me an error.
Do you need to calculate the the days between "Books checked out" and "return date"?
If yes you can use Formula(Number) datatype and use this formula DATEVALUE(return date)-DATEVALUE(Books checked out)
Please let mw know if it helps?
Thanks,
Saravana
Thank you Saravana for the reply. I can try this formula on some other formula field.