Tag Archives: RDLC Get time from Date/Time value stored as text

How to show Time from DateTime Rdlc Report Field

One of my recent requirements involved retrieving just the time portion of a records value,  generally the  we have the data type saved as a date/time format. First of all we want to show only time at rdlc report . so, this is easiest way to show time or if you want to show date.

First :: For Time.

=FormatDateTime(First(Fields!LoginTime.Value, “DS”), DateFormat.LongTime)

First :: For Date.

=FormatDateTime(First(Fields!LoginTime.Value, “DS”), DateFormat.ShortDate)

Rdlc DateTime Formula

Leave a comment

Posted by on January 7, 2015 in Crystal Report


Tags: , , , ,