[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 856
  • Last Modified:

SSRS Dates

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)

Open in new window

0
December2000
Asked:
December2000
  • 3
  • 3
1 Solution
 
mlmccCommented:
Try this

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

mlmcc
0
 
December2000Author Commented:
So, it is not condtion to show the last day of the month?
0
 
mlmccCommented:
What do you mean?

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

mlmcc
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
December2000Author Commented:
THANK YOU!
0
 
December2000Author Commented:
How do you take the time off?
0
 
mlmccCommented:
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now