Member Avatar for Dimansu

Hi
I am using RDLC in .Net framework for my reports. I have a field StartDate and it can be null in the database.I want to show the date as 02/12/2010 .
My code is,
=Format (Fields!StartDate.Value,"dd/MM/yyyy")
But in the report it shows "dd/MM/yyyy".

When there is no formatting i.e when the code is,
=Fields!StartDate.Value
the date is shown correctly.
Can anyone help me to sort this out?
thnx in advance

  • 3 Contributors
  • 3 Replies
  • 201 Views
  • 2 Years Discussion Span
  • Latest Post Latest Post by Wai Zin Hnin
Member Avatar for kvprajapati

>RDLC in .NET frmaework Date formatting 

=iif(IsNothing(Fields!StartDate.Value),"02/12/2010", Format(Fields!StartDate.Value,"dd-MMM-yyyy") )
Member Avatar for Dimansu

Hi,
Thnx for replying.I found the error.In the dataset i have given type as string for StartDate.

Member Avatar for Wai Zin Hnin

if you want date format dd-mm-yyyy, you can use Replace function like that Replace(Fields!date,"/","-") this is work for me :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.