Forum Discussion
Sharepoint Library Created and Modified Dates
Hello. I have a question about Files Created dates and retention Policies. If when i create my site y upload lots of files to a library at the same time, the file created date shows as the date ...
ganeshsanap Thank you so much, I'm very new to working with flow and http requests, and that worked almost perfectly - it updates the 'created' date, but it's a day behind - here is the screenshot, so where WFCreated is 17th, it puts the created date as 16th? I'm guessing it's time zone related, but I'm not sure how to put this in the http body - thank you for your help
Where exactly in the world are you?
Your date is most likely not in the correct zimezone format. so try this formula
@{convertTimeZone(item()['WFCreated'],'<Your Time Zone>','UTC','dd/MM/yyyy HH:MM')}
<Your time zone> is your local time zone....
I use "W. Europe Standard Time" as a value for my timezone, you can get yours from https://www.ge.com/digital/documentation/meridium/V36160/Help/Master/Subsystems/AssetPortal/Content/Time_Zone_Mappings.htm
(from the column "Standard Time Zone Name")
If that does not work, then also try switching the timezone parameters:
@{convertTimeZone(item()['WFCreated'],'UTC','<Your Time Zone>','dd/MM/yyyy HH:MM')}
Your date is most likely not in the correct zimezone format. so try this formula
@{convertTimeZone(item()['WFCreated'],'<Your Time Zone>','UTC','dd/MM/yyyy HH:MM')}
<Your time zone> is your local time zone....
I use "W. Europe Standard Time" as a value for my timezone, you can get yours from https://www.ge.com/digital/documentation/meridium/V36160/Help/Master/Subsystems/AssetPortal/Content/Time_Zone_Mappings.htm
(from the column "Standard Time Zone Name")
If that does not work, then also try switching the timezone parameters:
@{convertTimeZone(item()['WFCreated'],'UTC','<Your Time Zone>','dd/MM/yyyy HH:MM')}