How do I remove the trailing 0 from my year in my date

Question

0.00/5 (No votes)

See more:

Hi Guys

Would like to know if anyone would be able to assist.

About a week or 2 ago,something changed on my production server not sure if there were changes made from the networking team or if windows updates that were released that could have caused the issues but for some reason my application now reads a CDate as 02018/01/02 instead of 2018/01/02.

I have ran the code on my dev machine, and have deployed and tested the service on the QA/ and pre-prod environments and they all work fine, its only on the production server that i am having this issue.

What I have tried:

I have checked the regional settings and they dont seem to have changed.
Debugged/ and tested on other servers and the service runs fine with no issues

Posted 1-Jan-18 19:25pm

IsiR_19

Updated 3-Jan-18 1:27am

Add a Solution

Comments

Maciej Los 2-Jan-18 2:43am

Does the date value is stored as a date or as a string? Can you post exact value stored on server?

3 solutions

Solution 3

Found the issue, the service was running under a different user account, when logged in found the year had 5 y in regional settings

Posted 3-Jan-18 1:27am

IsiR_19

Comments

Maciej Los 3-Jan-18 7:38am

As i mentioned in my answer, you'll never get such of troubles, when you'd use date data type instead of string.
Cheers,
Maciej
;)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2018-01-01T20:54:00

There's nothing wrong with using CDate function, but i'd recommend to use newer technics to convert string to date/time value, because of several reasons. More you'll find here: Type Conversion Functions (Visual Basic) | Microsoft Docs[^]

Please, check this: Parsing Date and Time Strings in the .NET Framework | Microsoft Docs[^]
So, DateTime.Parse or DateTime.ParseExact is that what you're looking for.

In general: you have to use date instead of string data type to avoid several problems in a future. Note, that different CultureInfo[^], which may cause the date (stored in a string) to be not convertible.

A_Griffin · Accepted Answer · 2018-01-01T22:57:00

Solution 2

You can use String.Format("{0:yyyy/MM/dd}", DateObject)

Posted 1-Jan-18 22:57pm

A_Griffin