Perform Age calculation using Formula Columns in Dataverse / Dynamics 365

Below we have created a new field of Data Type Formula and Formula Data Type as Whole Number Specify the following formula. RoundDown(DateDiff(birthdate, UTCNow(), TimeUnit.Days) / 365.25, 0) Below we see the field in action. UTC current date is 10th Wednesday July 2024 for the below example. Also checkout the helpful video – and the … Continue reading

Published on: July 10, 2024

Learn more

Nishant Rana's Weblog – Everything related to Microsoft .NET Technology

Everything related to Microsoft .NET Technology

Blog image

Nishant Rana's Weblog – Everything related to Microsoft .NET Technology

Everything related to Microsoft .NET Technology

Learn more

More from this blog

$Fixed – “The relative url contains invalid characters. Please use a different name. Valid relative url names cannot ends with the following strings: .aspx, .ashx, .asmx, .svc , cannot begin or end with a dot, cannot contain consecutive dots and cannot contain any of the following characters: ~ ” # % & * : ? / \ { | }. “ error while creating SharePoint Document Location – Dynamics 365 / Dataverse$

Fixed – “The relative url contains invalid characters. Please use a different name. Valid relative url names cannot ends with the following strings: .aspx, .ashx, .asmx, .svc , cannot begin or end with a dot, cannot contain consecutive dots and cannot contain any of the following characters: ~ ” # % & * : ? / \ { | }. “ error while creating SharePoint Document Location – Dynamics 365 / Dataverse

We were using the below code to create a sharepointdoucmentlocation record through a C# Console App....

Data Migration of Quote and Quote Product – few key points (Dataverse/Dynamics 365/ SSIS)

Below are the different out-of-the-box statecode and statuscode for the Quote table. Status (stateco...

Recent and Pinned options are available now for multi-session app’s sitemap (e.g. Customer Service Workspace)

As we would have observed now we have the Recent and and Pinned records option available for the Cus...

Select record quickly inside Lookup control – Model-driven app /Dynamics 365

There is a small enhancement added to the Lookup Control as part of Release Wave 2. After performing...

Fixed – CRM service call returned an error: An error has occurred when retrieving metadata for CRM entity ‘table’: The source argument contains duplicate keys – Dataverse/ Dynamics 365 / SSIS

Recently while trying to retrieve OptionSet Metadata using our favorite KingswaySoft SSIS Toolkit we...

Fixed – CRM service call returned an error: The number of decimal places on quantity needs to be 0 or less for Quote Product (Dynamics 365 / Dataverse/SSIS)

While running an SSIS Package that creates Quote Product records, we got the below error – CRM servi...

Fixed – The term ‘Connect-PnPOnline’ is not recognized as the name of a cmdlet, function, script file, or operable program – PowerShell

If you are getting the below error even after running the Install-Module PnP.PowerShell command, it ...

Relevant topics:

Perform Age calculation using Formula Columns in Dataverse / Dynamics 365

Related posts