Order bar chart by Date Timestamp field

[#1]

Hi

I have loaded a field into Qlikview called ContactCreatedDate which contains dates in the format:

DD/MM/YYYY hh:mm:ss

I am using this field as a dimension in a bar chart with the expression:

=monthname(ContactCreatedDate)

Which formats it as Jan - 2009, Jun - 2012 etc. But when I try and order the bar chart by date it doesn't work. I have tried adding the ContactCreatedDate to the expression in the sort tab but this has no effect. Any ideas would be greatly appreciated!

Thanks

[#2]

Try this instead:

date(ContactCreatedDate, 'MMM - YYYY')

[#3]

Right after I posted this I checked the 'Numeric Value' box in the sort tab and it works fine now. More luck than skill!