+ Start a Discussion
amitashtekaramitashtekar 

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.

PRTKPRTK

Hi

 

Did you tried

 

StartDate__c + (365 * Years)

 

regards

amitashtekaramitashtekar

Yes. I have tried it. But it creates lag of few days because of leap and non-leap years.