need to change date formate

[yadav_anil782]

Dear All,

i have date in month-year format like (march-2015) but i want to change this format  in 1-march-2015 , so plz  help if any body can help .

Apr-13

Apr-14

Apr-15

Aug-10

Aug-11

Aug-12

Aug-13

Aug-14

Aug-15

Dec-10

Dec-11

Dec-12

Dec-13

Dec-14

Feb-11

Feb-12

Feb-13

Feb-14

Feb-15

and want to change in-

1-Apr-13

1-Apr-14

1-Apr-15

1-Aug-10

1-Aug-11

1-Aug-12

1-Aug-13

1-Aug-14

1-Aug-15

1-Dec-10

1-Dec-11

1-Dec-12

1-Dec-13

1-Dec-14

1-Feb-11

1-Feb-12

[petter]

Load Script or in the App (GUI) in a chart?

[tresesco]

Date(Date#('Apr-13', 'MMM-YY'), 'DD-MMM-YY')

Or,

Date(Date#(DateField, 'MMM-YY'), 'DD-MMM-YY')

[petter]

I presume that the Apr-13 is in a text format then it could be done like this:

=Date#( '1-' & DateField1 , 'd-MMM-YY')

or in script:

Date#( '1-' & DateField1 , 'd-MMM-YY') AS DateField2

[prma7799]

Try...

=Date(Date#('Apr-13', 'MMM-YY'), 'DD-MMM-YY') .

[PrashantSangle]

Hi,

You can use monthstart()

try like

Monthstart(Date#(DateField, 'MMM-YY'))

Regards