Date field for month start

[Anonymous]

Hi All,

I loaded data from Jan'15 to Jan'16( 13 Tables). now I need to add one date column that contains only start date of the month.

P FA.

Thanks,

Krishna.

Emp. Id	Employee Name	DOJ	Gender
458	A	02-May-96	Male
126	B	06-Feb-12	Male
140	C	01-Mar-13	Male
148	D	01-Aug-13	Male
150	E	02-Sep-13	Female
151	F	16-Sep-13	Female
1540	G	21-Oct-13

Emp. Id	Employee Name	DOJ	Gender	Month_HR
458	A	02-May-96	Male	01-01-2015
126	B	06-Feb-12	Male	01-01-2015
140	C	01-Mar-13	Male	01-01-2015
148	D	01-Aug-13	Male	01-01-2015
150	E	02-Sep-13	Female	01-01-2015
151	F	16-Sep-13	Female	01-01-2015
1540	G	21-Oct-13	Male	01-01-2015

[Kushal_Chawda]

How do you recognize that this data is from jan 15 to jan 16?

[Anonymous]

Hi Try this ,

MonthStart(Month_HR)

[avinashelite · Accepted solution]

if you need only the 01-01-2015 for all then , you can add a column like

makedate(2015,01,01) as Month_Hr

if you want it dynamically please tell us how to to identify the month

[its_anandrjs]

What is the logic for field Month_HR should be 01-01-2015

Regards

Anand

[Anonymous]

Hi,

I loaded data from Excel Sheets.Date fields are Date of joining, Effective date. KPI is Head count VS Every Month.

Regards,

Krishna