How To Find the Saturday Date From Given Month [Resolved]

Posted by Pallubhosale under Sql Server on 2/21/2014 | Points: 10 | Views : 1714 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi,

If I Enter The OpDate AS 03-02-2014 Then I want to find the incumming Saturdays Date.

For e.g. I Enter The OpDate = '03-02-2014 ' Then SturdatDate ='08/02/2014'

Pallavi

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Bandi on: 2/21/2014 [Member] [MVP] Platinum | Points: 50

0	refer http://stackoverflow.com/questions/6982061/how-to-get-saturdays-date-or-any-other-weekdays-date-sql-server make use of function available in the above link Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Pallubhosale, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Kshaik on: 2/21/2014 [Member] Starter | Points: 25

0	SELECT DATEADD(WEEKDAY,6,'03-02-2014') Pallubhosale, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Pallubhosale on: 2/25/2014 [Member] Starter | Points: 25

0	Thanks Bandi. Got Answer from your link Pallavi Pallubhosale, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts