!String was not recognized as a valid DateTime

Help
, , ,
1

Hello I am having the same problem even after I tried upper solutions.

  1. I make a string with datetime.now.tostring
  2. then I make a date variable with parseexact using string made in step one
  3. then after I make a new string with datevariable.tostring

image
image787×658 23.6 KB

2

Why are you trying to do that? Just testing things?

3

This picture is testing, but in real code, I need to take a date from excel, and substract 6 days to send a mail on new date(6 days before). I find out that its the problem in excel variable type

4

ParseExact expects valid format string matching the content of the input string.
In your case the format string is likely invalid.

Better use CDate() function.

Cheers

5

Date value in Excel is not Datetime but OADate

6

What to do in that case? I’m receiving that excel from HR and maybe it’s not possible for them to change format cause program is generating that file for them. CDate() is not working.

Best Regards

EDIT:
image

I’ts not the same problem

7

So here it is string, right?
What is the format of the string? Is is “dd.MM.yy”?

8

When i type a string inside ParseExact like DateTime.ParseExact(“07.01.20”,“dd.MM.yy”,Globalization.CultureInfo.InvariantCulture).AddDays(-6)
It is working

but when i put assigned string from excel(it seems as same format,look in the picture) it doesn’t work

DateTime.ParseExact(strDate,“dd.MM.yy”,Globalization.CultureInfo.InvariantCulture).AddDays(-6)
It is working

9

Check for any leading/trailing spaces/tabs etc. in the string from excel. It’s often a problem.

10

also pay attention that your excel has one blank first line…

11

Im making working copy DT from original excel, so it maybe makes wrong types