2 Replies Latest reply on Jul 21, 2015 1:43 AM by venkata sreekanth

# How to find the starting date of the month

Hi All,

I 'm new to tableau. I want to know the functions which is related to starting data of the month and week no's for the month in tableau..

I want to derive the following things based on the today date.

TODAY() - to day date,

1.Month of today.

2.Starting date of the month.

Thanks & Warm regards,

Venkata Sreekanth

• ###### 1. Re: How to find the starting date of the month

Hi Venkata

I think these are what you want...

1. DATENAME('month',TODAY()) = July

1a) DATEPART('month',TODAY()) = 7

2) DATETRUNC('month',TODAY()) = 01/07/2015 00:00:00

2a) DATE(DATETRUNC('month',TODAY())) = 01/07/2015

Source: Date Functions

Cheers

Mark

• ###### 2. Re: How to find the starting date of the month

Hi Mark,

Thanks for u r quick reply...

I want to know the starting date of the month(i.e, Current month is July Starting date of the month is 01st July 2015) .

my concern is i want to calculate the weeks that is from month starting date on wards....

Ex:

1st july 2015 is the date .

Month Startd date is 01

Week No 1(ie. 01 july 2015 to 4th july 2015)

week no 2(i.e, 05 july 2015 to 11th july 2015

like i want to calculate the week till last date of the month...