Post reply

dateadd expression

  • April 5, 2011 at 1:36 pm

    #248227

    hi guys, I have a tsql script which converts my integer value into a datetime 00:00:00 by using:

    CONVERT(VARCHAR(8), DATEADD(ss, myintfield, 0) ,114) as Time , i am trying to find an expression which will be equivalent to this for my report in Visual studio.

    I tried

    =Format(DateAdd("s",12600, Fields!myintfield.Value)) but i keep getting ##error

  • April 5, 2011 at 3:23 pm

    #1307745

    figured it out 🙂

    =Format(TimeSerial(0,0,Fields!myint.Value),"HH:mm:ss")

    hope it helps someone some day 🙂

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

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