how to set more than one date format in web application

Question

0.00/5 (No votes)

See more:

Hello Friends,

I need a solution for date format. My scenario is if user change a date format then through out application date format will be same for all controls which is independent of system culture.

How can i achieve this and this and where i set that format so if user change format then easily reflects the application

And my project supported more than one format i.e. dd/MM/yyyy and mm/dd/yyyy.

please suggest me a link or reference.

Thanks in Advance.

Posted 6-Jul-11 0:10am

vaibhav salwe

Updated 6-Jul-11 0:44am

Ramalinga Koushik

v2

Add a Solution

Comments

Syed Salman Raza Zaidi 6-Jul-11 6:20am

Store your date in string type column(varchar or nvarchar) in database

OriginalGriff 6-Jul-11 6:27am

That is a very bad idea: always store dates as Date or DateTime format. Otherwise you cannot do searches or filters based on them. In addition, to meet the OP requirements, you would have to store the same data in two different string formats. What happens when a third is addded?

3 solutions

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)

OriginalGriff · Answer 1 · 2011-07-06T00:28:00

Solution 1

You shouldn't try to change the culture - which controls the date format - it could confuse the user.
But, if you need specific format dates, then use the DateTime.ToString method. There is an explanation of the various formats here: Formatting a DateTime for display - format string description[^]

Posted 6-Jul-11 0:28am

OriginalGriff

Comments

[no name] 7-Jul-11 0:23am

Good Call OriginalGriff. My 5 for you.

Deepthi Aravind · Answer 2 · 2011-07-06T00:32:00

Solution 2

Hi...
You can use ToSTring("dd/MM/yyyy") to change the date format...
store the format into database..
Whenever you want to format the date, you can access the date format from database and if the user entered any date format..You can save that format into database..

Posted 6-Jul-11 0:32am

Deepthi Aravind

Updated 6-Jul-11 17:52pm

v2

Comments

shefeekcm 7-Jul-11 0:42am

ToSTring("dd/MM/yyyy",cureentdate)

shefeekcm · Answer 3 · 2011-07-06T18:36:00

Solution 3

Hi ,
you can use this to cahnge date format.

String.Format("{0:yyyy/M/dd HH:mm}", date)
regards,
shefeek

Posted 6-Jul-11 18:36pm

shefeekcm