Hello how can i load the date of my field as "year-month"? It's know "day-month-year"
Can you attach some sample dates you used in the application. When I checked this '05/01/2012' I got
The date which is loaded is know 1-5-2012 and i want 2012-5
Then check with thisDate(Date#(DateField,'D-M-YYYY'),'YYYY-M')
Check file attached. The same expression works for me. Can you attach sample file you are working.
I used this in the script and it returns again 0
STARTDATUM = Date(Date#(STARTDATUM,'D-M-YYYY'),'YYYY-M'),
Check with this if jagan mohan suggestion is not working.
Does'nt work returns '0'
Can you post sample date format you have used in these expressions?
Retrieving data ...