Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ajvctrindade
New Contributor

Date Format

Hi,

I'm new on this and I have made an app based on a excel file.

On that excel file I have a field with values like "01-Apr-2014". This is a date. However, the Qlik does not recognize it as a date and I need to make a order by this field.

Thanks for your help,

   António Trindade

Tags (1)
1 Reply
ajvctrindade
New Contributor

Re: Date Format

Hi,

I investigate a little further and found this document.

http://community.qlik.com/docs/DOC-3102

I tried date(date#([«FIELD_NAME»],'DD-MMM-YYYY')) and it seems to work.

Thanks anyway,

    António Trindade