topic Re: Fetch Day from date in QlikView

Fetch Day from date

Sun, 25 Jan 2015 06:20:32 GMT

Hi Everyone,

i have a field 'Date' having value '16-JUN-2014'

i want only day from the date field i.e 16

tried day(date) it didnt worked

any suggestions are highly appreciated.

Regards

Tausif Khan.

robert_mika — Sun, 25 Jan 2015 06:44:41 GMT

What about LEFT(Date,2)

its_anandrjs — Sun, 25 Jan 2015 06:52:28 GMT

Hi,

It seems your date is not in date format then first convert it into date format

Load

Day(Date(Date,'DD-MMM-YYYY')) as DDMMMYYYY_Day

From Source;

Date(Left(Date,2),'DD')

Regards

Anand

MarcoWedel — Sun, 25 Jan 2015 08:48:46 GMT

Day(Date#(Date, 'DD-MMM-YYYY'))

PrashantSangle — Sun, 25 Jan 2015 08:55:14 GMT

Hi,

You can achieve it various way

1) using date#()

day(date#(Date,'DD-MMM-YYYY')) as day

day(date(date#(Date,'DD-MMM-YYYY'))) as day

date(date#(Date,'DD-MMM-YYYY'),'DD') as day

2) using subfield()

subfield(date,'-',1) as day

Regards

Clever_Anjos — Sun, 25 Jan 2015 14:11:23 GMT

it seems your using a string, not a date,

try subfield(Date,'-',1)