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

[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!!! 😀

[Mira_Ghaly]

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

[rampprakash]

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-...

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

[ArisTale]

Hi Mira,

Where can I find this Process settings? 

Regards,

Alexandra

[ArisTale]

Hi,

Can you elaborate more on Javascript? Any working solution?

Regards,

Alexandra

[Mira_Ghaly · Accepted solution]

@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