Month Help

[mahitham]

Hi Experts,

Can any one please help me to extract the Month like Jan, Feb to Jul from the below field.

Thanks in advance.

[arvind_patil]

Hi Mahitha,

Please try below:

Month(Date#(Month,'YYYYMM')) as  Monthname,

Thanks,

Arvind Patil

[mahitham]

Hi Arvind,

I have tried in the backend. The field is showing null.

[Anonymous]

Try

Month(Date(Date#(Month,'YYYYMM'),'MMM-YYYY')) as  Monthname

[mahitham]

Hi Neetha,

Thanks or your reply. The expression is working in UI. But when I have copied the same expression in the backend its showing null.

[manoj217]

Month(Date(Date#(Month,'YYYYM'),'MMM-YYYY')) as  Monthname

[tresesco]

How (statement/script) did you create the Month field in the script?

[manoj217]

She wants to extract month from the date field am i right.

same script will work in backend also but check the format of your data for date# then transform into required format

left(Date(Date#(Month,'YYYYM'),'MMM-YYYY'),3) as  Monthname

[mahitham]

Hi Tresesco,

Please find the below script and UI screen shot.

When I have copied the backend expression in UI getting correct month format but in by the backend Month Transform field getting null.

[mahitham]

Hi Manoj,

I have tried left () but its not working