Post reply

Last day of last year

  • May 17, 2012 at 2:35 pm

    #1489365

    Mark Fitzgerald-331224 (5/17/2012)

    Lynn Pettis (5/17/2012)

    riya_dave (5/17/2012)

    i want last day pf previous year,formula i correct ,its working in sql,

    but i want to put same in ssrs expression

    Have you looked up a few posts in this thread?

    No one can say I didn't try Lynn. I give up now, bye bye. He won't read this anyway.

    Fitz

    Oh, thank you for the work you did. I haven't worked with SSRS much so you saved me a lot of head scratching and effort.

  • May 21, 2012 at 12:50 pm

    #1490628

    ok.

    i got solution ,the way ssrs works is it doesnt count 0 ,so in ssrs textbox expression ,i need to put something like this

    DATEADD("d",-1,DATEADD("yyyy",DATEDIFF("yyyy","1/1/1900",Fields!T.Value),"1/1/1900"))

    instead of 0 , i need to put 1/1/1900

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply