topic Re: date in QlikView

date

rathnam_qv — Thu, 18 Jul 2013 05:39:50 GMT

Hi all,

explain how it will works

date(date#(Month,'MMM'),'MMM')as Monthes;

Thanks!!!!

Smiley

er_mohit — Thu, 18 Jul 2013 05:43:10 GMT

date(date#(Month,'MMM'),'MMM')as Monthes

because in your month field then date# tells you the format of Month i.e in Jan

and the date function gives tells you the format in which you want i.e also a 'MMM'

so if date# format corrects then date function also correct

so, it gives you right answer as expected

hope it helps you

er_mohit — Thu, 18 Jul 2013 05:48:19 GMT

see the attached file of date hope it helps you

Thu, 18 Jul 2013 05:48:51 GMT

date(date#(Month,'MMM'),'MMM')as Monthes;

here date#() function tells the format of your datefield.

and date() function tells the in which format you want the datefield.

er_mohit — Thu, 18 Jul 2013 10:51:03 GMT

if your problem resolved then mark it as either helpful or correct anwer so that it might be helpful for other developer