Problem with Dayname function

[#1]

Hello, I'm very very new to Qlikview.  I have a problem with Dayname function along with another problem with Day but i guess solving this one will solve the other too.

I'm trying to make a dashboard from the data I take from a SQL database.

Time is held on a DOCUMENT_Date field on the database  in "2013-11-12 00:00:00.000" format.

When I use DayName ("DOCUMENT_DATE") the output list is in DD.MM.YYYY (i.e 01.11.2013) format instead of day names.

I tried DayName ("DOCUMENT_DATE", 'YYYY-MM-DD') and  DayName ("DOCUMENT_DATE", 'YYYY-MM-DD hh:mm:ss[.fff') but both gave me blank lists.

Also the problem about the Day function is that it's giving me months list instead of a day list but I guess solving the above will solve it too. I hope I'm not being very optimistic

What am I doing wrong?

[#2]

Once again a blank list

I don't get it..why is not working?

DOCUMENT_DATE is like "2013-11-12 00:00:00.000" in Database. Isn't it YYYY-MM-DD hh:mm.ss.fff format? Am I seeing things wrong?

This data is only for November so I'm sure we are not mixing months and days.

[tresesco]

Could you please upload a sample app with small data set directly from DB?

[#4]

Sorry I can't upload any data from the database due to agreements between client and firm

I managed to get the day list from another table but now they are shifted by 1. For example it's showing that 1st of November was a saturday where it was a Friday. How can I fix this shift?