Create date from day, month & year

Help Studio
,
1

Hi,

I have extracted rows of data from Excel in the string of (MM/dd/yyyy)

How do i transform this string variable into a date variable? I need this transformation in order to test if a date is “too old” in an if-function.

Thanks in advice.

2

@Karsten_Bertelsen Try this:

DateTime.ParseExact(yourDateString,“MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture)

3

@Karsten_Bertelsen
DateTime.ParseExact(YourDateString, “MM/dd/yyyy”, CultureInfo.InvariantCulture)
ensure:
grafik

4

Hi @supermanPunch & @ppr
Thanks for your suggestions!

I am getting the following error when trying to implement the suggestion: image

5

row(3).toString is needed

6

@ppr that solved the error, but not im getting this format exception
image

The excel file contains the format as “M/dd/yyyy” but i cant seem to figure out what im missing. -I corrected the suggestion to:
DateTime.ParseExact(yourDateString,“M/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture)

7

was your input, right? In case of you have to deal with different formats let us know, we can modify the statement.

For analysing debug / breakpoint and have a look into the datatable

8

If you got that error, then it suggests that your excel already have the dates as DateTime format and you dont need all this… Actually sorry, not the case, but when you do the ToString, if it was date format, then you are there changing its format… So if it really is string, do like this instead:
DateTime.ParseExact(Ctype(row(3),String),"MM/dd/yyyy", Nothing)