07 Nov 2016 18:08

Joined:	11/12/2010
Level:	Silver
Points:	53

Points:	3

Display blank value if date column contains NULL

Hi.
In my mvc application, I have modal as,
public class Leave
{
public DateTime CreatedDate{ get; set; }
}

In view, code is like,
@Html.DisplayFor(modelItem => item.CreatedDate)

Here, I have an issue, if this date is NULL, it display value, 01-01-0001.
Here, I want to keep column value as blank. How can i do that without changing datatype of column.

#768240

07 Nov 2016 18:33

Joined:	18/12/2008
Level:	Gold
Points:	2921

Points:	4

Hi,

As you mentioned like you don't want to change the datatype but what to showcase it has NULL.
You can go for Nullable Date parameter.


Nullable < DateTime > nullDateTime; // This for Date along with Timestamp

You can declare this nullable datatype as datetime and then you can use it as regular datatype.

Declaration


Nullable  nullDT;

Once you assign the values to nullDT you can check for the null ability.


if (nullDT != null)
            {
               Alert("Its not Null");
            }
else
           {
              Alert("");
           }

Thanks,
Mani

#768243

08 Nov 2016 06:36

Joined:	30/04/2012
Level:	Gold
Points:	7233

Points:	2

Here is the example code snippet for how to display blank value if date column contains NULL

 IF ISNULL([Date]) THEN ""
ELSE STR(YEAR([Date])) + "-" + STR(MONTH([Date])) + "-" + STR(DAY([Date]))
END

Useful reference : https://community.tableau.com/thread/140522

#768251

08 Nov 2016 18:01

Joined:	15/12/2015
Level:	Gold
Points:	1308

Points:	3

Hi,
Your datetime field needs to be nullified, otherwise when the class instance is created, compiler sets it to minimum datatime value i.e. '01-01-0001'.
Use this:


   [Display(Name = "Created Date")]
    [DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:dd/MM/yyyy}")]
   public Nullable<DateTime> CreatedDate{ get; set; }

Display blank value if date column contains NULL

About dotnetspider.com

Quick Links

General

Services