help on date

[#1]

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.

[sunny_talwar]

Try this out:

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

[Anonymous]

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')

[robert_mika]

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

[#5]

Already I tried same as you suggest but no result

it shows in date field all null values.

[robert_mika]

Post your Excel file

[sunny_talwar]

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

[#8]

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)