date

[#1]

Hi All,

I have a field which has month year ie MMMYYYY and I need to use this field and get a date as evry first of that month.

example: if the month year is Apr 2013 I need teh value as 1 Apr 2013,

jan 2013 as 1 jan 2013.

Please anybody can help.

Thanks in advance

[nilesh_gangurde]

Hii,

Use the below mentioned script at load time.

Monthstart

(DAte(DATE#(Field_Name ,'MMM-YYYY')))  as  New_Field_Name

Hope this will help.

-Nilesh

[AbhijitBansode]

You can make use of makedate function.

May be like below:

Date(makedate (2013,04),'D-MMM-YYYY')

- second parameter to the makedate function is month number.

I will suggest you to create new column in the script (may be [Month #]) using month name field.

[Gysbert_Wassenaar]

date#(MyDate,'MMMYYYY') will create dates that are the first day of the month. It's not clear from your description if your monthyear field contains a space between the month or not. Adjust the formula as needed.

[#5]

TRY THIS

=Date(Date#('Apr 2013','MMM YYYY'),'DD-MM-YYYY')

[er_mohit]

tRY THIS IN TEXT OBJECT

=date( date#('01' &'Apr 2013','DDMMM YYYY'),'DD MMM YYYY')