[Solved] Date format working locally error after publishing on IIS

trisetia...

SOLVED CLOSED ACTIVE ANSWERED
User: trisetia302
Posted: on Jul 21, 2021 06:06 AM
Forum: IIS Configuration
Answer: 2
Views: 9530

Hi Guys,

I'm get trouble when project finished and publish on IIS server. The trouble is Date Format can change itself after it is run on IIS Server. - Format Date in Database is 2021-09-05 (yyyy-MM-dd) (year-month-date)

After project publish on IIS server the Date Format is - Format Date in IIS Server is (09-05-2021) (MM-dd-yyyy)(month-date-year). This is invalid date format in Indonesian.

I have try to format that date format using string.format() in code behind.cs like this below.

txttgl_jatuh_tempo.Text = string.Format("{0:dd-MM-yyyy}", rdr["tanggal_jatuh_tempo"].ToString());

The code above is working properly when deployed on visual studio and get correct result of date format, but after project completed and deployed/running on IIS server the date format was change itself with this date format (09-05-2021) (MM-dd-yyyy)(month-date-year).

Of course this this date format make user confused because correct Indonesian date format is (date-month-years) (dd-MM-yyyy).

Any help could be appriciate.

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 2

Reply
ANSWER
User: dharmendr
Replied: on Jul 21, 2021 06:24 AM
Modified: on Jul 21, 2021 06:51 AM
Report

Hi trisetia302,

Use below code to format.

string tanggal_jatuh_tempo = rdr["tanggal_jatuh_tempo"].ToString();
txttgl_jatuh_tempo.Text = DateTime.ParseExact(tanggal_jatuh_tempo, 
                          new string[] { "yyyy-MM-dd", "MM-dd-yyyy", "dd-MM-yyyy", "yyyy-dd-MM" }, 
                          System.Globalization.CultureInfo.InvariantCulture, 
                          DateTimeStyles.None).ToString("dd-MM-yyyy");

trisetia...

0 3

Reply
ANSWER
User: trisetia302
Replied: on Jul 21, 2021 06:40 AM
Report

@Andrea

@dharmendr

Alhamdulilah, Problem Solved Sir.

Thanks so much for the help.

This code working properly sir.

DateTime tglJatuhTempo = Convert.ToDateTime(rdr["tanggal_jatuh_tempo"].ToString());
txttgl_jatuh_tempo.Text = string.Format("{0:dd/MM/yyyy}", tglJatuhTempo);

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

[Solved] Date format working locally error after publishing on IIS

Company

Explore

Follow us

Contact Us