Click here to Skip to main content
15,895,283 members
Search within:


How to set date forat as mm/dd/yyyy in web server in asp.net
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
ASP.NET4
Hi
Iam exporting data to excel which as date columns . In local system date column takes a system format .so no issues. When I configured in Webster and I run the application I get the report ( excel) date columns in differt format . how I want to write coding to get. Mm/ddyyyy in webserver can any one help me .


Thanks
Posted
Add a Solution
Comments
PIEBALDconsult 12-Dec-15 12:27pm    
Please use an ISO8601-compliant date format -- YYYY-MM-DD -- when writing output.
But Excel is likely storing the values as a numeric value (as it should). Excel can then display it however you wish by setting the format in Excel.
I think your issue is with Excel; "fix" it there.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
How I manage system date formate dd/MM/yyyy and MM/dd/yyyy?
How to convert datetime in the format dd/MM/yyyy hh:mm:ss:tt to yyyy/MM/dd hh:mm:ss tt in ASP.NET with C#?
Date Input textbox dd/MM/yyyy
Convert mm/dd/yyyy to dd/mm/yyyy
convert date from "dd/MM/yyyy" to "MM/dd/yyyy"
how to set calendar selected date in mm/dd/yyyy and insert into sql server 2005
storing a date in 'dd/MM/yyyy' in sql server 2008
Display date as DD/MM/YYYY format.
converting dd/mm/yyyy to mm/dd/yyyy in asp.net
how to convert mm/dd/yyyy format of date into dd/mm/yyyy format in sqlExpress

Advertise
Privacy
Cookies
Terms of Use
Last Updated 12 Dec 2015
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web04 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900