Hey SonaliB,
Please refer below sample.
Add root element in your xml file and then select node by elements.
XML
<?xml version="1.0" encoding="utf-8" ?>
<records>
<record>
<CH_Code>3DR</CH_Code>
<Channel>DR3</Channel>
<AirDate>2018-01-01</AirDate>
<Start>06:10</Start>
<Duration>150</Duration>
<Program_Title>Morgengymnastikken</Program_Title>
<Original_Title>Morgengymnastikken</Original_Title>
<Aka_Title></Aka_Title>
<Episode_Title>Tonet krop, løbeteknik og fridans</Episode_Title>
<Ori_Episode_Title>Tonet krop, løbeteknik og fridans</Ori_Episode_Title>
<Episode_Number></Episode_Number>
<Channel_Country>Denmark</Channel_Country>
<Synopsis>Morgengymnastikken på DR3 er et program der giver dig en dejlig fornemmelse i kroppen. I dette afsnit skal vi lave tre forskellige træninger. Vi starter med at tone vores krop med Yvonne, og så skal vi lave løbetræning med Peter.</Synopsis>
<Actors></Actors>
<Director></Director>
<Presenter></Presenter>
<Guests></Guests>
<Production></Production>
<Distrib></Distrib>
<Country>Denmark</Country>
<Product_Year></Product_Year>
<Chn_Category></Chn_Category>
<Language>Danish </Language>
<Ori_Language>Danish</Ori_Language>
<Category>Factual</Category>
<Type>How to...</Type>
<Content>Health</Content>
<Event_ID>2106932372</Event_ID>
<Program_ID>28193738</Program_ID>
<Emission_Duration>0</Emission_Duration>
<Season_Number></Season_Number>
<Series_ID>23576258</Series_ID>
<Part_Number></Part_Number>
<Tot_Nb_Parts></Tot_Nb_Parts>
<Live/>
<Pilot/>
<First_Showing/>
<Last_Showing/>
<Subtitled/>
</record>
<record>
<CH_Code>3DR</CH_Code>
<Channel>DR3</Channel>
<AirDate>2018-01-01</AirDate>
<Start>08:40</Start>
<Duration>40</Duration>
<Program_Title>The Late Show med Stephen Colbert</Program_Title>
<Original_Title></Original_Title>
<Aka_Title></Aka_Title>
<Episode_Title></Episode_Title>
<Ori_Episode_Title></Ori_Episode_Title>
<Episode_Number></Episode_Number>
<Channel_Country>Denmark</Channel_Country>
<Synopsis>Den amerikanske komiker og talkshowvært Stephen Colbert disker op med bidsk politisk satire og spændende gæster.</Synopsis>
<Actors></Actors>
<Director></Director>
<Presenter></Presenter>
<Guests></Guests>
<Production></Production>
<Distrib></Distrib>
<Country>Denmark</Country>
<Product_Year></Product_Year>
<Chn_Category></Chn_Category>
<Language>Danish </Language>
<Ori_Language>Danish</Ori_Language>
<Category>Discussion</Category>
<Type></Type>
<Content></Content>
<Event_ID>2106932487</Event_ID>
<Program_ID>33883469</Program_ID>
<Emission_Duration>0</Emission_Duration>
<Season_Number></Season_Number>
<Series_ID>1</Series_ID>
<Part_Number></Part_Number>
<Tot_Nb_Parts></Tot_Nb_Parts>
<Live/>
<Pilot/>
<First_Showing/>
<Last_Showing/>
<Subtitled/>
</record>
</records>
Namespaces
C#
using System.Xml;
using System.Globalization;
using System.Text.RegularExpressions;
VB.Net
Imports System.Xml
Imports System.Globalization
Code
C#
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
Regex regex = new Regex(@"(((0|1)[0-9]|2[0-9]|3[0-1])\/(0[1-9]|1[0-2])\/((19|20)\d\d))$");
string FilePath = Server.MapPath("~/XMLFile.xml");
XmlDocument doc = new XmlDocument();
doc.Load(FilePath);
XmlNodeList nodeList = doc.SelectNodes("/records/record/AirDate");
foreach (XmlNode node in nodeList)
{
bool isValid = regex.IsMatch(node.InnerText);
if (!isValid)
{
DateTime yyydate = Convert.ToDateTime(node.InnerText);
string result = yyydate.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
}
}
}
}
VB.Net
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not Me.IsPostBack Then
Dim regex As Regex = New Regex("(((0|1)[0-9]|2[0-9]|3[0-1])\/(0[1-9]|1[0-2])\/((19|20)\d\d))$")
Dim FilePath As String = Server.MapPath("~/XMLFile.xml")
Dim xd As XmlDocument = New XmlDocument()
xd.Load(FilePath)
Dim nodelist As XmlNodeList = xd.SelectNodes("/records/record/AirDate")
For Each node As XmlNode In nodelist
Dim isValid As Boolean = regex.IsMatch(node.InnerText)
If Not isValid Then
Dim yyydate As DateTime = Convert.ToDateTime(node.InnerText)
Dim result As String = yyydate.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture)
End If
Next
End If
End Sub