c# Datetime deserialization problem in camt54 (iso 20022)

Question

I apologize in advance if this question has already been asked, but I could not find anything that could help me understand how to solve the problem.

The thing is, when trying to deserialize a camt54 of a particular bank, my procedure goes wrong. Investigating the problem I realized that the desrializer fails to convert this tag:

<ToDtTm>2020-11-18T24:00:00+01:00</ToDtTm>

Obviously I understand why. The C # datetime format does not include 24:00:00 and the debugger returns the error: "The string '2020-11-18T24:00:00+01:00' is not a valid AllXsd value"

But from what I understand in xml it is an accepted value.

Unfortunately this is the first case that happens to me. I have deserialized a lot of camt54 and have never had any problems until now.

How can I tell the deserializer to correctly read the value inserted in the xml?

Thank you in advance. Matteo.

This is the ISO 8601 format for times. Using 24:00 to represent midnight where allowed in earlier versions of the standard, but not in the 2019 revision - wikipedia. See also https://stackoverflow.com/questions/3556144/how-to-create-a-net-datetime-from-iso-8601-format — JonasH, Nov 24 '20 at 09:45
Thank. So basically is the maker of the xml which is using a deprecated standard ? — matsnake86, Nov 24 '20 at 10:39

score 1 · Answer 1 · answered Nov 24 '20 at 12:25

Use following :

    class Program
    {
        static void Main(string[] args)
        {
            string xml = "<root><ToDtTm>2020-11-18T24:00:00+01:00</ToDtTm></root>";
            StringReader sReader = new StringReader(xml);
            XmlReader xReader = XmlReader.Create(sReader);
            XmlSerializer serializer = new XmlSerializer(typeof(root));
            root root = (root)serializer.Deserialize(xReader);
        }
    }
    public class root
    {
        public DateTime _ToDtTm { get; set; }
        public String ToDtTm {
            get {
                return _ToDtTm.ToString(@"yyyy-MM-dd\Thh:mm:sszzz"); 
            }
            set {
                string date = value.Replace("T24", "T00");
                _ToDtTm = DateTime.Parse(date); }
            }
    }

c# Datetime deserialization problem in camt54 (iso 20022)

1 Answers1