DT convert to String

Hi,

i need your help again :wink:

I have a DT = ETA that it looks like
MessageBox

we are the correct Assigne command so that I have a string “DATE” and a string “TIME”
If possible, use this format for the date = “dd.MM.yyyy”
and the Time in the European format = 19:00 (without PM)

Thanks in advance ! I won’t be able to answer today.

BR
Jürgen

@juergenh1975

Just wanted to know is the Date and time are in on row or two rows?

For Date conversion you can check below for your reference

Reference

Hope this may help you

Thanks

1 Like

grafik

DateTime.ParseExact("25-Nov-2021","dd-MMM-yyyy", CultureInfo.InvariantCulture).toString("dd.MM.yyyy")
CDate("7:00 PM").toString("HH:mm")

strDateValue = dtData.Rows(0)(0).toString.Trim
strTimeValue = dtData.Rows(1)(0).toString.Trim

ensure System.Globalization is added to the imports

Two rows

Thanks for the videolink

ok, i will test that tomorrow.

Thanks very much