how to change all the day from Date attribute into day 1

[#1]

Hi,

I have Created_date in my Table

1/30/2013

2/27/2014

2/26/2014

5/1/2014

But I want to change in the load script like shown below:

1/1/2013

2/1/2014

2/1/2014

5/1/2014

Could you please advise me

Best

Robert

[ashfaq_haseeb · Accepted solution]

Hi,

use month start finction.

Like below

load Date,

MonthStart(Date) as Date1;

load * Inline

[

Date

1/30/2013

2/27/2014

2/26/2014

5/1/2014

]

Regards

ASHFAQ

[#3]

Thanks.

[ashfaq_haseeb]

welcome