topic Re: Date Format in QlikView

Date Format

krishna20 — Sun, 06 Jul 2014 08:30:38 GMT

hi Friends,

I'm having Date format like this 34562.432566.I have used year(Date Field) and Year(Date#(date Field,'M/D/YY'),'MM/DD/YYYY').But i'm not able to retrieve.Please anyone can help me out.

Regards

Krishna

Re: Date Format

Anonymous — Sun, 06 Jul 2014 08:39:52 GMT

Date ( floor( [Date Field] ) ) should return the date.

Re: Date Format

krishna20 — Sun, 06 Jul 2014 08:42:42 GMT

Dear Mark,

No Result

Regards

Krishna

Re: Date Format

Anonymous — Sun, 06 Jul 2014 08:56:11 GMT

What does just [Date Field] return ?

Do bear in mind Qlikview is case sensitive on field names.

Re: Date Format

ashfaq_haseeb — Sun, 06 Jul 2014 09:08:02 GMT

Hi Kalyan,

May be you have text date so convert it to Date first.

try below

year(date#(Date,'M/D/YYYY h:mm:ss[.fff] TT') as Year

or try to post some sample data.

Regards

ASHFAQ

Re: Date Format

Anonymous — Sun, 06 Jul 2014 10:17:21 GMT

Hi,

Try below

Date(Floor(Num#([DateField]))) as Date,

Year(Num#([DateField])) as Year

Re: Date Format

MarcoWedel — Wed, 23 Jul 2014 10:02:58 GMT

Hi Krishna,

maybe your decimal separator is not set to '.' i.e. your input 34562.432566 is not treated as a number.

Try

SET DecimalSep='.';

in your script.

To test the difference try different Decimal Separators e.g. using this script:

SET DateFormat='MM/DD/YYYY';
SET TimestampFormat='MM/DD/YYYY hh:mm:ss[.fff]';

SET DecimalSep='.';

table1:
LOAD * Inline [
Date Field
34562.432566
];

once recognized as a number, 34562.432566 should deliver this date, timestamp and year result:

hope this helps

regards

Marco

Re: Date Format

Anonymous — Wed, 23 Jul 2014 10:16:39 GMT

Try this

=date(num(34562.432566))

This should work.

Cheers!

Laxmi

Re: Date Format

aveeeeeee7en — Wed, 23 Jul 2014 10:28:50 GMT

Use this:

Subfield(NUM(DATE(YOURDATEFIELD,'DD-MM-YYYY')),'.','1') AS NEWDATE

Regards

Aviral Nag