Hi there,
My input value in the input data is as below but my output of the same value is getting changes, how can I get the same values as input in my output?
The input json field for effectiveDate have values of like this
2022-08-24T00:00:00.000+0000
but in my output its coming like this, whereas in build DT the column data type is selected as string.
08/24/2022 05:30:00
How about this expression
DateTime.ParseExact("08/24/2022 05:30:00","MM/dd/yyyy hh:mm:ss",System.Globalization.CultureInfo.InvariantCulture).ToString("yyyy-MM-ddTHH:mm:ss.fff+ffffK")
Regards
Gokul
@Gokul001
my input has from JSON is below, which is getting changed to “08/24/2022 05:30:00” now when I used the code provided by you it’s getting output as “2022-08-24T05:30:00.000+0000” but I need the below as output.
2022-08-24T00:00:00.000+0000
P.S in my build DT should I changed the data type from string to something else?
Chevk out this expression
DateTime.ParseExact("08/24/2022 05:30:00","MM/dd/yyyy hh:mm:ss",System.Globalization.CultureInfo.InvariantCulture).ToString("yyyy-MM-ddT00:00:00.fff+ffffK")
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.