From JSON to XML

Question

Maybe u know how for JSON structure Apples: {
"Red": 5,
"Yellow" : 7
"DateFrom": "2020-05-19"
}
recieve XML ? I can't write to XML DateFrom. She's empty

P.S : ( for MS sql☹️)

Answer 1

For MS SQL Use this format YYYYMMDD. So it will be 20200519

Answer 2

Ore I try, thank u dear🥰

Answer 3

I cast "DateFrom" in varchar and it's help , but my senior programmer want to save type DateFrom as datetime