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:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@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!

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
ArisTale 72 on at

Like (0)

Report

Hi Mira,

Where can I find this Process settings?

Regards,
Alexandra

Was this reply helpful? Yes No
ArisTale 72 on at

Like (0)

Report

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

Regards,
Alexandra

Was this reply helpful? Yes No
Verified answer

Mira Ghaly 11,413 Moderator on at

Like (1)

Report

@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

Was this reply helpful? Yes No