Post reply

Find previous 25 th month

  • June 22, 2008 at 10:25 pm

    #381286

    Hi All,

    I want to find the previous 25th month from current date.

    Any suggestion or code please.....

    Thanks in advance.....

  • June 22, 2008 at 10:35 pm

    #832454

    Use DATEADD function. For example:

    select getdate(), dateadd(m, -25, getdate())

    2008-06-23 10:03:11.3172006-05-23 10:03:11.317

  • June 22, 2008 at 10:46 pm

    #832456

    Thanks Suresh for you valuable reply..........:)

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

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