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:
Download
dharmendr
on Jul 21, 2021 06:24 AM
on Jul 21, 2021 06:51 AM
2
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");
@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);