Apex Code Development You need to sign in to do that
Don't have an account?
Kazjam Date calculation help needed
Hi I am new to all this formula stuff and would like some help please. I have been asked to create a date calculation based on:
The date requested (date field) + no of days contracted (text field) and from this I need to
get the = End Date (date field). So if I request a start date of 10/10/2008 and I have a contract which is 50 days, I want it to tell me the end date of my request?
When I try it the formula comes up with expected a date and got text?
Thank you in advance.
This will convert the text to a numeric value if the text entered is a legitimate number.
Another option that would make this more sound would be converting the No_of_Days_Contracted__c to a Number data type. If someone enters alpha characters into this field the formula above will fail and you'll get an error calculation. You could also place validation rules on the same field to make sure the values fall within acceptable ranges.
Hi, thanks but I am still having problems, have I choosen the wrong formula choice?
I still can't seem to get this to work, the no of contract is days is text field. The required start and end dates are date fields?
so my required start date is the 27th October and I have 50 days contracts for that so my end date will be 50 days after the start date. Sorry if I seem to be being daft here.
End date 1 (Number) =Make sure the formula field is of Date data type, rename it to be End_Date__c and use just the following formula:
No need to place the 'End_Date__c = ' portion into the formula field.
I was being stupid I apologise to those trying to figure out what I was doing. I have this working now, thank you Nathan for your help.:smileyhappy: