topic Re: select the date number in QlikView

select the date number

Fri, 06 Dec 2013 09:15:01 GMT

hi, I want to return the value of D in M/D/YY format. pls help me

MK_QSL — Fri, 06 Dec 2013 09:25:31 GMT

Considering that you have D as Day

=Date(MakeDate(Year(Today()),Month(Today()),Day),'M/D/YY')

maternmi — Fri, 06 Dec 2013 09:28:07 GMT

Hi Dushan,

I guess you you have a date field as DD/MM/YYYY and would like to change it to M/D/YY. If not pleaec precise your question.

Try this:

anytablename:

laod

date(datefiled, 'M/D/YY')

resident

Name of table which consist the date field

Fri, 06 Dec 2013 09:29:59 GMT

try this

Date(Date#(datefield,'M/D/YY'),'D')

Fri, 06 Dec 2013 09:49:50 GMT

my problem in as an example i have a date 1/12/2013 so i want to get only 1 as the date. how can i get only D filed in M/D/YYYY format

maternmi — Fri, 06 Dec 2013 09:52:50 GMT

Try this:

Day(datefield)

jagan — Fri, 06 Dec 2013 09:53:18 GMT

Hi,

Try like this

=Day(DateDimensionName)

=Date(DateDimensionName, 'D')

Hope this helps you.

Regards,

Jagan.