"yyyy" is read as 0001 instead of 2020

caduque · June 17, 2020, 4:07am

Hi!

I was using the code below to get the correct cutoff value. It was working before but when I ran it again, the year changes from 2020 to 0001

varSample.ToString(“yyyy-MM-dd”) should return 2020-01-31 but now it returns 0001-01-31

SenzoD · June 17, 2020, 4:13am

@caduque, Where are you reading the cutoff date value from?

Can you use a write line before trying to convert it to this format, just to see if the value was extracted correct from where you are getting it.

supermanPunch · June 17, 2020, 4:39am

@caduque What Value are you passing to varSample?

Srini84 · June 17, 2020, 4:47am

Check below

Hope this helps

Thanks

Yoichi · June 17, 2020, 6:15am

Hi,

It might be CultureInfo matter. Can you try the following?

.ToString("yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture)

Regards,