C# – how to format date in crystal report as dd-mm-yy using formula field

ccrystal-reportscrystal-reports-2010net

I use

ToText(Cdate({dt_vw_Rept_Attend.StartDate}),"dd-MMM-yyyy")

formula to formate datetime string in crystal report to display day-month-year but it doesn't work for me.

if i have datetime in my database as 7/28/2015 12:00:00 AM

so according to function it should be 28-Jul-2015

but i am getting this again 7/28/2015 12:00:00 AM

I need your help to resolve this. thanks in advance.

Best Answer

Try below code.

ToText({dt_vw_Rept_Attend.StartDate}, "yyyyMM")           ==>    “201101″
ToText({dt_vw_Rept_Attend.StartDate}, "dd-MMM-yyyy")       ==>   “15-Jan-2011″
ToText({dt_vw_Rept_Attend.StartDate}, "dd MMM yyyy")       ==>  “15 Jan 2011″
ToText({dt_vw_Rept_Attend.StartDate}, "MM/dd/yy")           ==>  “01/15/11″
ToText({dt_vw_Rept_Attend.StartDate}, "dddd, MMM d, yyyy") ==>  “Saturday, Jan 1, 2011″
ToText(Cdate({dt_vw_Rept_Attend.StartDate}))

And for more information http://crystaltricks.com/wordpress/?p=149 Hope you solve

Related Solutions

C# – How to escape braces (curly brackets) in a format string in .NET

For you to output foo {1, 2, 3} you have to do something like:

string t = "1, 2, 3";
string v = String.Format(" foo {{{0}}}", t);

To output a { you use {{ and to output a } you use }}.

Or now, you can also use C# string interpolation like this (a feature available in C# 6.0)

Escaping brackets: String interpolation $(""). It is new feature in C# 6.0.

var inVal = "1, 2, 3";
var outVal = $" foo {{{inVal}}}";
// The output will be:  foo {1, 2, 3}

R – Else part never getting executed in crystal report formula field

Maybe you have some null value in your fields - in such case crystal just returns null. You then need either "convert null values to default" setting for report or explicit testing against nulls.

Best Answer

Related Solutions

C# – How to escape braces (curly brackets) in a format string in .NET

R – Else part never getting executed in crystal report formula field

Related Topic