topic Re: help on date in QlikView

help on date

Tue, 16 Jun 2015 20:35:02 GMT

Hi all,

In my log file I have data and date formate should be 'DD-MMM-YY'

But once I loaded into qvw, it shows in wrong format.

Below is the attachment for ur reference.

I tried with combinations of date & date# functions but didn't work properly.

Plz help me out.

Re: help on date

sunny_talwar — Tue, 16 Jun 2015 20:36:33 GMT

Try this out:

Date(Date#(mod_date, 'DD-MMM-YY'), 'DD-MMM-YY') as mod_date

Re: help on date

Anonymous — Tue, 16 Jun 2015 20:39:06 GMT

try to define the Format of your datefield under Settings/Documents/Number and define your datefield to 'DD-MM-YYYY'

if that does not work force the dateformat with: date(date#(yourdatefield,'DD-MM-YYYY'),'DD-MM-YYYY')

Re: help on date

robert_mika — Tue, 16 Jun 2015 20:40:40 GMT

Or your date in Excel is just a format or in your Qlikview Script change this setting

Re: help on date

Tue, 16 Jun 2015 20:42:47 GMT

Already I tried same as you suggest but no result

it shows in date field all null values.

Re: help on date

robert_mika — Tue, 16 Jun 2015 20:45:33 GMT

Post your Excel file

Re: help on date

sunny_talwar — Tue, 16 Jun 2015 20:46:18 GMT

then I suggest loading the mod_date as it is without any Date() or Date#() function and check what format QV is reading it, my guess is, QV is not seeing it as DD-MMM-YY (Its just excel formatting).

Once you know what formatting it has use it in bold part

Date(Date#(mod_date, 'HERE'), 'DD-MMM-YY') as mod_date

Re: help on date

Tue, 16 Jun 2015 20:58:18 GMT

Robert you can see my attachment

SET DateFormat='DD/MMM/YYYY';

Yes Robert as u suggest after change the date format it works fine.But some other time if we are going to load with another date format, again we will be facing same problem.

Is there any more ideas(in the load script is it possible?irrespective any date format we have)