How to display date as start date of month?

[#1]

Hi,

have date filed like below i want to display date as start date of month

Date

2011-02-23

2011-02-25

2011-03-01

2011-05-30

Output like below

2011-02-01

2011-02-01

2011-03-01

2011-05-01

please help

thanlks

[#2]

You can try makedate(year(date),month(date),01).

Alternately, MonthsStart(1,date).

The Help menu is a valuable resource!

[jagan]

Hi,

Use MonthStart(DimensionName)

Regards,

Jagan.