Solved

# SSRS Dates

Posted on 2012-08-17
794 Views
I am doing a crystal conversion... how do I convert this for use in SSRS
``````dateVar aodt := Date({VW_RPT_INV_STANDARD_FORMAT_AO.AS_OF_DATE});
DateSerial (Year(aodt),Month(aodt),0)
``````
0
Question by:December2000

LVL 100

Accepted Solution

Try this

=DateSerial(DatePart("yyyy",Fields!As_Of_Date.Value), DatePart("m",Fields!As_Of_Date.Value), 0)

mlmcc
0

Author Comment

So, it is not condtion to show the last day of the month?
0

LVL 100

Expert Comment

What do you mean?

In Crystal that will get you the last day of last month

mlmcc
0

Author Closing Comment

THANK YOU!
0

Author Comment

How do you take the time off?
0

LVL 100

Expert Comment

Is it 0:0:0

Try this

=DateSerial(DatePart("yyyy",Fields!As_Of_Date.Value), DatePart("m",Fields!As_Of_Date.Value), 0,0,0,0)

If you just want a Date try
Try this

=Date(DateSerial(DatePart("yyyy",Fields!As_Of_Date.Value), DatePart("m",Fields!As_Of_Date.Value), 0))

If it just in the display try formatting it.

mlmcc
0

## Featured Post

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.