Year and Month function coming blank in Date Filed

[niha]

Hello,

I am new to QlikSense. I loaded CSV files from MarkLogic. There is only one CSV file in data model . I wanted to do a  Preceding Load . I wanted to see Year , Month of [Date Paid ] field.  I wrote the code but it is coming blank. Please suggest.

[rogerpegler]

Try this instead of [Date Paid] = [Date Paid] in your load script

Date#([Date Paid],'YYYY/MM/DD') as [Date Paid]

[jonathandienst]

DatePaid is probably being loaded as a string. You need to convert to a  date before functions like Year(), Month() will work. Use the Date# function as described above, or like this:

Date(Date#([Date Paid],'YYYY/MM/DD')) as [Date Paid]

[niha · Accepted solution]

Thanks a lot. It worked. I was able to produce Year, Month , Day from [Date Paid]. I need YearMonth too. If I want to add YearMonth what I have to do?
Thanks,
Niha