i have created two Date &time field with the following details.
then I created another total time field, with data type as Date&time and Field type is Calculated. while giving action to the calculated field i am getting the follwing error:
You can't use new_startdate, which is of type dateTime, with the current operator.
can anyone help me in this?
*This post is locked for comments
Hello Vijay,
Unfortunately, You cannot use Calculation field to calculate two dates..
Source:
blog.sonomapartners.com/.../dynamics-crm-2015-calculated-and-rollup-fields.html
"Unfortunately I don't think you can subtract two dates. I just tried this in a calculated field (new_date1 - new_date2) and I got an error "You can't use new_date1, which is of type dateTime, with the current operator"."
And I tried it before, not supported.
Try to refer this link as well.
community.dynamics.com/.../357056
You can Try to achieve this by using Workflow or JavaScript as mentioned here in this
Example :
us.hitachi-solutions.com/.../duration-calculations-in-crm-with-little-or-no-customizations
I Hope this helps you.
Thanks.
Your Calculated field data Type should be Whole Number or decimal if you are trying to calculate duration.
Change the format to Date only
Refer this:
www.summitgroupsoftware.com/.../diffindays-calculated-field-datetime-fields
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (