Power Platform Community Forum Thread Details

hey,

i have an issue with time convert connector, for example my JSON that triggering the flow (HTTP end point) look like this:

{

"Date Created": "'2022-11-06 01:16:19'"

}

the flow is failing on an attempt to make time zone conversion:

the problem is that is failing only if the hour in the time stamp is - "01"

other hours and other time zones conversions was tried with no luck.

the time zone convert action:

the replace expression contains:

replace(replace(triggerBody()?['Date Created'],' ','T'),'''','')

did anybody came across with such issue?

thanks!

Eli.

Categories:

General topics

There are many formats supported by SQL Server - see the MSDN Books Online on CAST and CONVERT. Most of those formats are dependent on what settings you have - therefore, these settings might work some times - and sometimes not.

The way to solve this is to use the (slightly adapted) ISO-8601 date format that is supported by SQL Server - this format works always - regardless of your SQL Server language and dateformat settings.

The ISO-8601 format is supported by SQL Server comes in two flavors:

YYYYMMDD for just dates (no time portion); note here: no dashes!, that's very important! YYYY-MM-DD is NOT independent of the dateformat settings in your SQL Server and will NOT work in all situations!
or:

YYYY-MM-DDTHH:MM:SS for dates and times - note here: this format has dashes (but they can be omitted), and a fixed T as delimiter between the date and time portion of your DATETIME.

Hope this helps,
John