date format

[prabhas277]

Hi experts,

i have one field called month in that i have some data .the data like jan-14,fed-14 ...dec-14 now in list the data is like 1/1/14,2/1/14 like that. now my requirement is that will apper in the list box like jan-14,feb-14 like how we can achive that?

Regards,

prabhas,

[Anonymous]

Hi,

can you post sample data?

Is simplier to understand.

Thank you.

Regards.

[swuehl · Accepted solution]

Try

LOAD

     MonthName(month) as month,

....

in your load script.

[hari8088]

can u give more explanation

[settu_periasamy]

Hi,

You mentioned already you have month field like Jan-14, Feb-14.

You can directly put that in your listbox, right?

if you have the date field, then in the listbox Expression give

like this

=Date([Your date field],'MMM-YY')

[sunny_talwar]

Try this in the script:

Date(Date#(Capitalize(Month), 'MMM-YY')) as Date,

MonthName(Date#(Capitalize(Month), 'MMM-YY')) as MonthYear