Post reply

How to use Current date in Sql server 2005 reporting services.

  • December 19, 2008 at 6:40 am

    #216731

    Hi All,

    I am working on Sql Server 2005 Reporting Services (Cubes as a data source ). There is a requirement to get the employee details who are going to deallocate from the project and how many days left.

    like : (Allocation end date of the employee) - (Current Date )

    want to use as calculted member .Any build in function to use to get the current date.

    Thanks,

    Alok

  • December 19, 2008 at 10:23 am

    #915488

    getdate()


    Pradeep Singh

  • December 21, 2008 at 10:50 pm

    #915957

    Hello..:)

    I guess..you can use..=DateString() function also..to fetch Current date. It will display time also..but that can be formated according to our need...

    I hope..this should help!

    Thanks,

    Niraj

  • December 21, 2008 at 10:58 pm

    #915962

    alokkumar_srivastava (12/19/2008)

    Hi All,

    I am working on Sql Server 2005 Reporting Services (Cubes as a data source ). There is a requirement to get the employee details who are going to deallocate from the project and how many days left.

    like : (Allocation end date of the employee) - (Current Date )

    want to use as calculted member .Any build in function to use to get the current date.

    Thanks,

    Alok

    convert(varchar(),Getdate(),101)

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

Viewing 4 posts - 1 through 3 (of 3 total)

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