Qlik Tidbit – 6

If Data source has Date column with more than 3 characters for Month (possibly complete month name), it could be interpreted and used in QlikView/QlikSense as below.

date(date#(’08/September/2015′, ‘DD/MMMM/YYYY’), ‘MM/DD/YYYY’)

Note:

Date# – Interpreter function helps QV to understand the source format.

Date – Function used in QlikView to instruct the format that needs to be used for displaying, if format is not specified explicitly, default format will be taken.