Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

sticky date format

Hi, I have an xls with monthly price updates which i want add to my existing reports.

Problem is that this file has a manual month name instead of a real date format :

format is

'Jan 12

'Feb 12

'Mar 12

is there any way to fix this and convert it during load? I'd like to use it with my standard date island.

thanks for any input!

1 Solution

Accepted Solutions
whiteline
Honored Contributor II

Re: sticky date format

Hi.

You can use Date# function to convert strings into date format (dual).

In your case Date#(right(date, len(date)-1), 'MMM DD').

Then you can convert it with Date function:

Date(Date#(right(date, len(date)-1), 'MMM DD'), 'YYYY-MM')

2 Replies
whiteline
Honored Contributor II

Re: sticky date format

Hi.

You can use Date# function to convert strings into date format (dual).

In your case Date#(right(date, len(date)-1), 'MMM DD').

Then you can convert it with Date function:

Date(Date#(right(date, len(date)-1), 'MMM DD'), 'YYYY-MM')

Not applicable

Re: sticky date format

that's great, thanks alot!

Community Browser