Loading data

[#1]

Hello how can i load the date of my field as "year-month"? It's know "day-month-year"

[jagan]

Hi,

Use this

=Date(DateFieldName,  'YYYY-MMM')

Regards,

Jagan.

[CELAMBARASAN]

Hi,

     Check with this if jagan mohan suggestion is not working.

     Date(Date#(DateField,'DD-MMM-YYYY'),'YYYY-MMM')

[#4]

Does'nt work returns '0'

[#5]

Returns '-1'

[jagan]

Hi,

Can you attach some sample dates you used in the application.  When I checked this '05/01/2012'  I got

=Date('5/1/2012',  'YYYY-MMM')

2012-May

Regards,

Jagan.

[CELAMBARASAN]

Hi,

     Can you post sample date format you have used in these expressions?

Celambarasan

[#8]

The date which is loaded is know 1-5-2012 and i want 2012-5

[jagan]

Hi,

Try this

Date(Date#(DateField,'D-M-YYYY'),'YYYY-M')

Regards,

jagan.

[CELAMBARASAN]

Hi,

Then check with this
Date(Date#(DateField,'D-M-YYYY'),'YYYY-M')

Celambarasan