topic Re: calender in QlikView

calender

abhaysingh — Sun, 21 Sep 2014 06:09:02 GMT

i have date like july 13, june 13 , how can i make date from date???????

ashfaq_haseeb — Sun, 21 Sep 2014 06:45:12 GMT

Hi,

Can you attach few sample lines of data?

regards

ASHFAQ

its_anandrjs — Sun, 21 Sep 2014 06:45:21 GMT

Use Date# function for this.

Anonymous — Sun, 21 Sep 2014 06:57:41 GMT

set vDateString = 'july 13';

mMonths:

mapping load * inline

[MonthName, MonthNo

january,1

february,2

march,3

april,4

may,5

june,6

july,7

august,8

september,9

october,10

november,11

december,12];

let vMonthString = SubField(vDateString, ' ', 1);

let vYearString = 20 & SubField(vDateString, ' ', 2);

let vDate = MakeDate(vYearString, ApplyMap('mMonths', vMonthString), 1);

MK_QSL — Sun, 21 Sep 2014 08:06:43 GMT

Considering july 13 as July 2013.. You can create date as below...

=Date(Date#('july 13','MMMM YY'))

=Date(Date#('june 13','MMMM YY'))

Considering july 13 as 13/07/YYYY... You can create date as below with considering Year 2014...

=MakeDate(Year(Today()),Month(Date#('july 13','MMMM DD')),Day(Date#('july 13','MMMM DD')))