Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello how can i load the date of my field as "year-month"? It's know "day-month-year"
Hi,
Use this
=Date(DateFieldName, 'YYYY-MMM')
Regards,
Jagan.
Hi,
Check with this if jagan mohan suggestion is not working.
Date(Date#(DateField,'DD-MMM-YYYY'),'YYYY-MMM')
Does'nt work returns '0'
Returns '-1'
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.
Hi,
Can you post sample date format you have used in these expressions?
Celambarasan
The date which is loaded is know 1-5-2012 and i want 2012-5
Hi,
Try this
Date(Date#(DateField,'D-M-YYYY'),'YYYY-M')
Regards,
jagan.
Hi,
Then check with this
Date(Date#(DateField,'D-M-YYYY'),'YYYY-M')
Celambarasan