Can I concatenate 2 Date fields in a calculated column in Dataverse?

(0) Share

Report

Posted on by ArisTale

Hi,

I am a new Dataverse user and looking for help here.

I have created a table (in Dataverse) and 2 columns by type Date Only: RA_EstimatedEntry and RA_EstimatedLeave

Now I need one more column to show a concatenation of these 2 dates like a period. Should I use a calculation for this? How?

For example,

RA_EstimatedEntry - 01.01.2022

RA_EstimatedLeave - 15.01.2022

Period: 01.01.2022 - 15.01.2022

Thank you in advance!!! 😀

Categories:

Tables

Microsoft Dataverse

All responses (5)

Answers (1)

Verified answer

Mira Ghaly 11,409 Super User 2025 Season 1 on at

Like (1)

Report

Re: Can I concatenate 2 Date fields in a calculated column in Dataverse?

@ArisTale

Go to make.powerapps.com and open your solution and click add new item , Automation - process -workflow

And you can learn more about realtime workflows from the link below:

https://docs.microsoft.com/en-us/power-apps/maker/data-platform/configure-workflow-steps
ArisTale 72 on at

Like (0)

Report

Re: Can I concatenate 2 Date fields in a calculated column in Dataverse?

Hi,
Can you elaborate more on Javascript? Any working solution?

Regards,
Alexandra
ArisTale 72 on at

Like (0)

Report

Re: Can I concatenate 2 Date fields in a calculated column in Dataverse?

Hi Mira,

Where can I find this Process settings?

Regards,
Alexandra
Ram Prakash 5,179 Super User 2025 Season 1 on at

Like (0)

Report

Re: Can I concatenate 2 Date fields in a calculated column in Dataverse?

Hello @ArisTale

As per CALCULATED FIELD, you can use only date and time for Calculation,

Link for your reference : https://community.dynamics.com/crm/b/meganwalker/posts/difference-between-two-dates-with-calculated-fields

Else as suggessted by @Mira_Ghaly we are good to go with Realtime Workflow, else you can go with JavaScript.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

Blog : https://microsoftcrmtechie.blogspot.com
Mira Ghaly 11,409 Super User 2025 Season 1 on at

Like (0)

Report

Re: Can I concatenate 2 Date fields in a calculated column in Dataverse?

@ArisTale

Unfortunately you can't use calculated column for this purpose, so alternatively you can create a new text column called Period and use a power automate flow on When a record is created and Set the field using a concatenate compose data operation (This is in case you do not want the change to be reflected immediately on the form)

Alternatively you can use a synchronous process - Workflow

Below is the sample of the work flow:

My recommendation is if you want it to be synchronous (immediate reflection) use Process as above , otherwise use Power automate as it will give you more flexibility if you wanna modify the format of the date.

Hope this gives you an idea and let me know if you need more help!