You need to sign in to do that
Don't have an account?
amitashtekar
How to get return type as DateTime in formula fields
hello,
I am not able to get return type as DateTime in formula field.
I have selected the field type as DateTime.
But after processing date time i am not able to convert it to DateTime from Date.
I want to add number of years in a date time field.
If I use like below
StartDate__c + Years
It just add number of days to it.
If I use like below
StartDate__c + 365 * Years
It create lag of few days.
Does anyone have any idea of how to do it.
Hi
Did you tried
StartDate__c + (365 * Years)
regards
Yes. I have tried it. But it creates lag of few days because of leap and non-leap years.