Formula for future date in email body

[MB35]

Hi,

I have created a scheduled flow which sends an email every quarter to request a task to be completed.

Within the email body, I need to add a date to advise when the task is to be completed by. 

For example, the email which is sent on 13th January, would have a request to say 'please complete by 31st March' the next email goes on 13th April with the request to complete by 30th June. 

I was looking to to build a formula into the email body, however I'm unsure what the formula would be when the email goes out on different dates

Any help would be great. Thankyou

[Andrew_J]

@MB35 

You have a sheduled flow, so what about taking the date and time of the start say 13/01/2024 at 10:00 then by my reckoning adding 78 days to this in a compose action such as:

addDays(utcNow(),78)

The above would need to be formated in the date style you like.  I assume you know howto adapt the above to give you this formating.

Then using the compose action in the body of the email where you want ot notify them of the date for the task to be done by.

I hope that helps:

Regards,

Andrew

[MB35]

Hi, thankyou for this, please can you tell me how I would format it? Thanks

[Andrew_J]

@MB35,

I would sugest that somewhere in your email body add the expression I have indicated above with the date in.

I know the above are compose actions but you can add an expression too. 

You will have to format the date how you like but I am sure you can work that out depending on your location.

Regards,

Andrew