time stored in date

[juma_99]

Hello everyone,

I have created a recurring flow in which an end date is compared with today's date in an Excel and if they match, an email is automatically sent to the contact person from the Excel. This email contains a text with a date. However, the date with the time is now displayed in the email, although the date is stored in the Excel without the time. However, I only want the date without the time in the email. Can anyone help me here?

Thank you.

[Gericom]

Hi @juma_99 

you can use the FormatDateTime function  

formatDateTime( Your variabele from excel , Format of date notation between Single Quotation  for example ' dd/M/yyyy')

If you have any questions feel free to ask 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[juma_99]

Hi @Gericom ,

Thanks, But where can I specify this function? I created it as a date_granted with Initialize Variable and then set it as the variable in Excel. In the email I have now entered the function formatDateTime with the help of the variable date_granted. However, I get the error message that the expression is invalid. Do I have to do it differently?

[Gericom · Accepted solution]

@juma_99 

you can also use Format data by examples 

 here you can give the variable  

example value for you can take from a previews run 

desired output  how you want that variable to look 

and it will provide you with a function that you can use 

If you have any questions feel free to ask 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[juma_99]

@Gericom 

Perfect thank you very much, that helped me a lot. Can you possibly help me with another thing? I have several emails with different content that are sent to the same person on the same day. Is it possible to save these contents of the emails in a list beforehand and only send an email to the same person with all the information?

This would be perfect.

[Gericom]

hi @juma_99 

im happy this was helpful can you mark it as solved so other people can find the solotion 

this is possible but what is the issue you are facing ? 

If you have any questions feel free to ask 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[juma_99]

@Gericom

I don't know exactly what functions I have to use to create this list beforehand, so that the contents of the emails to the same person are stored beforehand and then sent collectively as one email. So that a person does not receive several emails on the same day. I haven't managed to save this before sending it and at the moment the same person gets several emails at the same time. Do you know how I do that?