What new functions would you like in formulas?

[Jakester]

Hi Marion,

You can set the date however you want if you create a formula text field and then use the "+" sign to combine day(), month(), and year() functions. I don't understand what you mean by "the latest user setting for time" - can you clarify?

[champ_vimal]

Can we have DATEADD(date1,date2)/DATEDIFF(date1,date2) functions?

Also HOUR(DATE)function?

Thanks,

Vimal

[Jakester]

Oooh - bump for a great idea! DateAdd would rock!

[JorgeSFDC]

Champ_Vimal,

Great idea on DATEADD() and DATEDIFF(). Add it to ideas.salesforce.com and I'm sure you'd get several votes. It will get visibility of the idea  to the Salesforce Product Management team and possiblity get it in the app soon.

Regards,

J

[champ_vimal]

Hi All,

Thanks for appreciating my idea of Date functions. 

I have posted the idea in the Salesforce Ideas community. Here is the link:

http://ideas.salesforce.com/article/show/10097697/DATEADD_DATEDIFF_functions_for_formulas

Please vote for same if you think it is really worth implementing it in Salesforce.

Thanks,

Vimal