2 Replies Latest reply on Aug 22, 2016 7:00 AM by Shikha Sen

# Calculate second Tuesday on the months from current date (Today(())

Team -

Please suggest. How to calculate second tuesday of the month from current date.

• ###### 1. Re: Calculate second Tuesday on the months from current date (Today(())

Dear Shikha - Try this expression to derive second Tuesday of the month from Today() function. This will return current month's Second Tuesday.

DATE(

DATETRUNC('week',

DATETRUNC('month',TODAY())+13,'Tuesday'))

1. This returns 1st Day of the Month: 1st August 2016 00:00 Hrs

DATE(

DATETRUNC('week',

DATETRUNC('month',TODAY())+13,'Tuesday'))

2. This returns 1+13 = 14th Day of the Month : 14th August 2016 00:00 Hrs

DATE(

DATETRUNC('week',

DATETRUNC('month',TODAY())+13,'Tuesday'))

3. This returns the Tuesday between 8-14 th day of August: 9th August 2016 00:00 Hrs

DATE(

DATETRUNC('week',

DATETRUNC('month',TODAY())+13,'Tuesday'))

4. This returns the Date part of the Expression: 9th August 2016

DATE(

DATETRUNC('week',

DATETRUNC('month',TODAY())+13,'Tuesday'))

Hope you get a good explanation.

Thanks,

Manideep

• ###### 2. Re: Calculate second Tuesday on the months from current date (Today(())

Thank you Manideep. Its working.