Skip to Content
0
Former Member
May 18, 2015 at 08:01 PM

Datetime syntax from SQL to CR

17 Views

Hello,

I have the following date format in SQL.

DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,'2011')+3,0))

When I ran it in SQL, the result is:

2011-03-31 23:59:59.000 It returns the year (2011), the month (03), last day of the month (31), and time (23:59:59.000).

How we can do it in CR?

Thanks.

-Bill