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.
Solved! Go to Solution.
Hi @LeeS1eve ,
You could use formatDateTime() function to format the start time and end time:
Best Regards,
hi @LeeS1eve could you share us the Convert time zone error? because the correct way is use it xD
Proud to be a Flownaut!
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?
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.
Proud to be a Flownaut!
I've attempted the below which didn't work, what am i doing wrong (i imagine a lot...)
Hi @LeeS1eve ,
You could use formatDateTime() function to format the start time and end time:
Best Regards,
That has worked perfectly, thanks so much!
User | Count |
---|---|
100 | |
37 | |
26 | |
23 | |
16 |
User | Count |
---|---|
132 | |
52 | |
48 | |
36 | |
24 |