Convert yyyy-mm-ddThh:mm:ss into date yyyy-mm-dd

[Roger_CQ]

hello

i have this value “yyyy-mm-ddThh:mm:ss” in a string from a datatable and i want to convert into a date yyyy-mm-dd so i can use it for a if condition

Any help would be appreciated.

[ppr (Peter Preuss)]

@Roger_CQ
Welcome to the forum

Working with CDate:

CDate(YourStringVar).toString("yyyy-MM-dd")

[ppr (Peter Preuss)]

As an alternate with having more control over the parsing format we can also do:

In case of date conversion issues also have a look here for some initial analysis strategies:

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues

This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in hurry: Example Assignment Following Excel data will be processed and the corresponding Quarter is to calculate for the particular task date Input data: [input_raw] Quarter Calculation Quarter = CInt(Math.Ceiling(YourDateTimeVar.Month / 3 )) Initial Implementation [initial_flow_raw] tmpTaskDate = DateTime.ParseExact(row("Date").toString.Trim, "dd.MM.yyyy", Culture…

[Roger_CQ]

in both cases i have a error with the conversion string to date. i am trying to assign into a date variable

[Yoichi]

Hi,

FYI, another solution:

Strings.Left(yourString,10)

or

System.Text.RegularExpressions.Regex.Match(yourString,".*?(?=T)").Value

Regards,

[ppr (Peter Preuss)]

@Roger_CQ

i am trying to assign into a date variable

we do not reformat internally the datetime. so it will return a string

Also have a look here for some additional samples