Query Sharepoint online Calendar list showing different timings


Badge +4

Hi ,

I am querying a calendar list and showing it in a Send notification Email .

Instead of showing this 5/8/2020 12:00:00 AM-5/9/2020 11:59:00 AM    in the Email    5/8/2020 4:00:00 AM-5/9/2020 3:59:00 AM .

 

Any setting needs to be changed ?

 


2 replies

Userlevel 5
Badge +19

@raghavat is your site set to the same timezone that you are in? The Query action will pull the time from the list using the 'Site Time' vs. the 'Personal Time' which might be causing your issue.


 


Badge +4

@butlerj   Regional settings are fine . But it is always showing ISO format .

Reply