Click here to Skip to main content
Click here to Skip to main content

Tagged as

How to remove Time from DateTime on client side (aspx page)

, 23 Nov 2012 CPOL
Rate this:
Please Sign up or sign in to vote.
It's a simple but helpful tip and it's easy to implement

Introduction 

Usually we put the Data Type for column named "date" as datetime or smalldatetime. So it will by default attach a date whether we pass any time with date or not. For example if we pass "datetime" it will take both date and time  like "11/23/2012 1:28 PM" and it we pass "shortdate" then it will take "11/23/2012 0:00 AM" so there is nothing we can do if the Data Type is "datetime" or "shortdatetime". I needed to get rid of time so i searched and found a good solution that i am trying to share with everyone.

Background 

Recently i was in the situation like i told in my introduction section. My Data Type in database field for "SignUpDate" is "datetime". So it's taking both date and time i have nothing to do with this. but i needed to show only the date at the front end. On the other hand i may also need the time it the client wants it for any reason so i can't delete it. so i need to find a solution that will hide the time while it renders the page.

Using the code 

Here is the screenshot of my database fields.

 

Here is the problem i faced.

 

 

I just wanted to remove the time from the display

Here is my code for the solution:

//
// <asp:BoundField DataField="SignUpDate" HeaderText="SignUp Date" DataFormatString="{0:d}" />
// 

DataFormatString="{0:d}" 

This is the command we need to add with our "<asp:BoundField />" tag

The output will be like this as i want Smile | :)   the time is removed from the display

Thanks and Happy Coding.

License

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

Share

About the Author

dpalash
Software Developer Desme Bangladesh
Bangladesh Bangladesh
I have completed my Undergraduate from Khulna University of Engineering in Computer Science & Engineering. Now i am working as a Software Engineer at desme-Bangladesh on ASP.NET. I really love this technology and like to build my career with this only.
Follow on   Twitter   Google+

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.141216.1 | Last Updated 23 Nov 2012
Article Copyright 2012 by dpalash
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid