How To Fomat Start Time/End Time

[LeeS1eve]

Hi, 

I'm trying to convert the Start Time and End time taken from Get calendar view of events and displayed in an HTML table.

I have it displaying in the table but currently it shows as below - How can i get it to show in a more user friendly format (dd/mm/yy)?

Just to add - I have tried using the 'Convert time zone' but am having no success. My flow is shown below.

[ChristianAbata]

hi @LeeS1eve  could you share us the Convert time zone error? because the correct way is use it xD

[LeeS1eve]

Hi,

I actually get no errors. Just nothing happens, as if it's not in the flow.

I think it's likely that i am using it incorrectly, or placing it incorrectly in the flow. Is it possible for you to explain how i correctly implement it? 

[ChristianAbata]

Shure @LeeS1eve 

see the first field is to your Date data got from html table

Then UCT universal is used to dates that you don't know the GMT transtation wthat why I use allways universal and then my currect that is -5GMT, the last field is just a format you have some there.

[LeeS1eve]

Hi @ChristianAbata 

Thank you for that - which stage in my flow do i place that? 

[LeeS1eve]

I've attempted the below which didn't work, what am i doing wrong (i imagine a lot...)

[v-bacao-msft · Accepted solution]

Hi @LeeS1eve ,

You could use formatDateTime() function to format the start time and end time:

Best Regards,

[LeeS1eve]

That has worked perfectly, thanks so much!