C# modifying strings

Question

I'm working on an application in which I retrieve data from a database to be displayed in a table in my cshtml. One of the fields I'm calling is a date field. The data for it in the database is stored in the following format: MMDDYY i.e; 091504. For reasons I need not get into, the data has to be stored in that format in the database. I'm trying to figure out how I can modify its display to show 09/15/04 instead of 091504.

@model IEnumerable<BillingApp.Models.SERV_CHARGE_INT_RATE_NSF_PENALTY>

<table id="Test" class="tablesorter">
<thead>
<tr>
<th>Effective Date</th>
</tr>
</thead>


@if (Model.Count() == 0)
{
    <tbody>
    <tr>
        <td colspan="4">
            No Records match search criteria
        </td>
    </tr>
        </tbody>  
}  
else{
    <tbody>
    @foreach (var item in Model)
    {         
        <tr>
        <td>
            @Html.DisplayFor(modelItem => item.EFFECTIVE_DATE)
        </td>
        </tr>
    }
    </tbody>
    </table>

Is your date a string or an actual DateTime?

dodexahedron
– dodexahedron

2014-08-04 16:50:10 +00:00
Commented Aug 4, 2014 at 16:50 — dodexahedron
– dodexahedron, Commented Aug 4, 2014 at 16:50

Simon · Accepted Answer · 2014-08-04 16:59:13Z

2

If you use a DateTime object, you can try using [DisplayFormat] in your model.

Ex :

 [DisplayFormat(DataFormatString = "{MM/dd/yy}")]
 public DateTime EFFECTIVE_DATE { get; set }

If you are using a string instead of DateTime, you could consider converting the data type by using @ByteBlast's solution :

DateTime.ParseExact(item.EFFECTIVE_DATE, "MMddyy", CultureInfo.CurrentCulture);

edited Aug 4, 2014 at 16:59

answered Aug 4, 2014 at 16:49

Simon

1,60513 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

dodexahedron Over a year ago

Pretty sure he doesn't have an actual DateTime object. Otherwise, yes.

Simon Over a year ago

@dodexahedron If you are right, ignore my solution. But he said "is a date field".. !

Roman Mik Over a year ago

This is a good solution, but it would be good to explain how to convert his format into a DateTime object.

User 12345678 Over a year ago

Like this: var date = DateTime.ParseExact(item.EFFECTIVE_DATE, "MMddyy", CultureInfo.CurrentCulture);

Simon Over a year ago

@RomanMik Yes, if he does use a string instead of DateTime, which we don't know yet.

dodexahedron · Accepted Answer · 2014-08-04 16:49:21Z

0

There are many ways to handle this.

One would be to have your model class parse the dates coming out of the database into actual DateTime objects and then use those throughout your application (probably the best choice, if you need to do anything else with the dates).

Another would be to slice up the string when displaying it, if all you need to do is display the date. Something along the lines of this:

@foreach (var item in Model)
{         
    <tr>
    <td>
        @(item.EFFECTIVE_DATE.Substring(0,2))/@(item.EFFECTIVE_DATE.Substring(2,2))/@(item.EFFECTIVE_DATE.Substring(4,2))
    </td>
    </tr>
}

answered Aug 4, 2014 at 16:49

dodexahedron

4,6832 gold badges32 silver badges41 bronze badges

1 Comment

dodexahedron Over a year ago

If this solves the problem, please mark the question as answered so that it doesn't show up as an unanswered question on the front page any more. Thanks and happy coding!

Collectives™ on Stack Overflow

C# modifying strings

2 Answers 2

5 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related