Date convertion is returning a worng value.

[diegoadum]

Hi!! I'm trying to convert a date that I'm getting from SharePoint but the result is really odd.

The original date value in the SharePoint is 06/09/2018 (dd/mm/yyyy)

but the result of the formula is 

Here the formula I'm using!

convertTimeZone(items('Apply_to_each')?['Created'], 'Central Standard Time','Pacific SA Standard Time', 'ddmmyyyy')

Any idea?

Thank in advance!

[v-yamao-msft · Accepted solution]

Hi @diegoadum,

Please try the following code, I have made a test and it works fine:

ConvertTimeZone(triggerBody()?['Created'],'Central Standard Time','Pacific SA Standard Time','dd/MM/yyyy')

 

Best regards,

Mabel Mao

[diegoadum]

Thank for the tip! Maybe you can explain what the difference between items and TriggerBody is? 

[diegoadum]

In addition, I'm getting a null error now. Sorry, but I hit the accept as a solution too soon! AS you can see below I do have a value in the Created field, but Flow is not considering it as a valid value.

[diegoadum · Accepted solution]

Looking at your example I noticed that my mistake was to use the mm instead MM in the month conversion. I made the change in the formula and now is working as should!

so the formula now is like this:

convertTimeZone(items('Apply_to_each')?['Created'], 'Central Standard Time', 'Pacific SA Standard Time', 'dd/MM/yyyy')