Want to remove time from date in dropdownlist?

Question

This is my code by which i bind dropdownlist data from sql..i want to remove the time part from date...

string query = "select distinct PaperStartDate from HMDPaperManage ";
ddlPaperDate.DataSource = clsSqlFunctions.GetSelectedData(query);

ddlPaperDate.DataTextField = "PaperStartDate";
ddlPaperDate.DataBind();

23/04/2014 00:00:00:00

and i want

23/04/2014

Did you try to format the string representation of your date? — Soner Gönül, Jun 16 '14 at 11:50
Checkout this example and modify as required http://stackoverflow.com/a/17146281/1370442 — Luke Baughan, Jun 16 '14 at 11:51
You should trim it in DB query, like `CONVERT(VARCHAR(10),client_exp_date, 111)` and can check this for other formats http://technet.microsoft.com/en-us/library/ms187928.aspx — Vijay Singh Rana, Jun 16 '14 at 11:56

score 2 · Answer 1 · answered Jun 16 '14 at 11:51

2

string query = "select distinct DATEADD(dd, DATEDIFF(dd, 0, PaperStartDate), 0) from HMDPaperManage ";

try this solution

DATEADD(dd, DATEDIFF(dd, 0, PaperStartDate), 0) should take only date part

answered Jun 16 '14 at 11:51

faby

7,394
3
27
44

score 2 · Answer 2 · answered Jun 16 '14 at 11:51

2

You can replace the DropDownList values asbelow:

for(int i=0;i<ddlPaperDate.Items.Count;i++)
{
  ddlPaperDate.Items[i]=DateTime.ParseExact(ddlPaperDate.Items[i].Text,
      "dd/MM/yyyy HH:mm:ss",CultureInfo.InvariantCulture).ToString("dd/MM/yyyy");
}

answered Jun 16 '14 at 11:51

Sudhakar Tillapudi

25,935
5
37
67

score 1 · Accepted Answer · answered Jun 16 '14 at 11:51

1

Set the "DataTextFormatString to "d" i.e.

ddlPaperDate.DataTextFormatString = "d";

This gives the added benefit that you can change up how the date is formatted based on standard string.format() conversions.

For more info, see here

answered Jun 16 '14 at 11:51

iamkrillin

6,798
1
24
51

1

The syntax is not correct. It should be ddlPaperDate.DataTextFormatString = "{0:d}" . Just putting "d" caused my dropdown textfield to populated with a "d". – Dave Mar 13 '17 at 12:59

score 1 · Answer 4 · answered Jun 16 '14 at 11:52

You can just update your Query like

string query = "select distinct CONVERT(VARCHAR(12),PaperStartDate,103) as 'PaperStartDate' from HMDPaperManage ";
ddlPaperDate.DataSource = clsSqlFunctions.GetSelectedData(query);

ddlPaperDate.DataTextField = "PaperStartDate";
ddlPaperDate.DataBind();

In CONVERT(VARCHAR(12),PaperStartDate,103), 103 is the format code. You can have a lot of format codes. Below is the link for the other format codes: http://msdn.microsoft.com/en-us/library/ms187928.aspx

score 1 · Answer 5 · answered Jun 16 '14 at 11:57

1

You should trim it in DB query

string query = "select distinct CONVERT(VARCHAR(10),PaperStartDate , 111) from HMDPaperManage ";

Check this for other formats

http://technet.microsoft.com/en-us/library/ms187928.aspx

answered Jun 16 '14 at 11:57

Vijay Singh Rana

1,060
14
32

Want to remove time from date in dropdownlist?

5 Answers5