Expressing 30.12.11 as 'December 2011'

[Philip Jenks]

[WARNING: Newbie at work]

Does anyone know a way of expressing a numeric date field as just 'Month and Year' in text? I know it's possible to make it DISPLAY in that way, but I wonder if there's a calculation that can define a new field to turn 30.12.11 into 'December 2011'. I guess it would be something along the lines of:

If characters 4 and 5 are '1' and '2', then that's December, AND if characters 7 and 8 are '11' that's 2011.

Put me out of my misery.

Philip

[comment]

Not sure what you mean by "numeric date field". If it's a field of type Date, you can use a calculation =

GetValue ( "Jan¶Feb¶Mar¶Apr¶May¶Jun¶Jul¶Aug¶Sep¶Oct¶Nov¶Dec" ; Month ( YourDate ) ) & " " & Year ( YourDate )

to generate the text.

[Philip Jenks]

Hi Consultant

I think I'm in your debt again. I'll try this out and see how I get on.

How can I balance the ledger? What's the accepted way for people who get help on a forum to repay individuals (or the community) beyond the mere expression of thanks?

Philip

[Raybaudi]

Wasn't simpler:

MonthName ( YourDate ) & " " & Year ( YourDate )

[comment]

Doh! I don't know what I was thinking.

---

Actually, I do know what confused me - but that's no excuse. :bang:

[Raybaudi]

No need to blame themselves, you are always the best !