Retrieve data with date time variable using Lookup Data Table

[Ridwan_Satrio]

Hi good people, can anyone help me how to retrieve data from excel row with data variable in the form of date time. so I compared 2 pieces of string data to retrieve 1 date time data, but after running I experienced an error like below

[Ridwan_Satrio]

additional information: I use 2 excel files as input, so it’s not comparing from 2 sheets

[Ridwan_Satrio]

btw im try to use assign to create new var with this :
String var=Convert.ToDateTime(datetimevar).ToString(“dd.MM.yy”)

and the result like this:

[Lak_Ui (Lakshmi)]

DateTime.ParseExact(datetimevar, “MM/dd/yyyy”, CultureInfo.InvariantCulture).ToString(“dd.MM.yy”)

Try this

[Ridwan_Satrio]

thx for your response, let me try

[Vaibhav_Rajpoot_17 (Vaibhav Rajpoot)]

@Ridwan_Satrio
Try
Cdate("input ".ToString)

[Vaibhav_Rajpoot_17 (Vaibhav Rajpoot)]

@Ridwan_Satrio