Reverse date

[mentairia]

I have MOnth in name format and year in number format. I need it to create a date field for sorting purposes.

I tried several different methods none have worked is there a way to get "January" "2005" to read 01/01/2005. Day is not important month and year is all I care about.

Thanks

Tony D.

[aaa]

By calculation - on of ways:

B=Case(A="January 2005","01/01/2005",

.....................

....................

....................

)

[mentairia]

What do the dotted lines represent? Do I have to give it all varibles!

[aaa]

Look attachment!

Only 12 choice may be:

January 2005

February 2005

March 2005

....

.....

If you want post the part of your data.

Date.zip

Edited September 16, 2005 by Guest

[comment]

Try:

Date (

Div ( Position ( "janfebmaraprmayjunjulaugsepoctnovdec" ; Left ( monthNameField ; 3 ) ; 1 ; 1 ) ; 3 ) + 1 ;

1 ;

yearField

)

[mentairia]

Thanks :

AAA