topic Re: Date(floor) in QlikView

Date(floor)

Tue, 17 Feb 2015 12:01:56 GMT

Hi,

trying to fetch the date out of my timestamp field (SettlementTime) but it does not work for some reason, getting null values.

Date( Floor( Timestamp#(SettlementTime, 'DD/MM/YYYY hh:mm:ss')), 'DD/MM/YYYY')as SettlementDate

Timestamp (SettlementTime) format from my source data looks like below:

09/02/2015 10:30:44

Thanks in advance,

Olle

Re: Date(floor)

PrashantSangle — Tue, 17 Feb 2015 12:06:31 GMT

Hi,

Use

Subfield(SettlementTime,' ',1) as date

use date(floor(SettlementTime),'DD/MM/YYYY') as New_date

REgards

Re: Date(floor)

maxgro — Tue, 17 Feb 2015 12:08:37 GMT

I think you need 2 space between Y and h (because there are 2 spaces here 09/02/2015 10:30:44)

date(floor(Timestamp#('09/02/2015 10:30:44', 'DD/MM/YYYY hh:mm:ss')))

Re: Date(floor)

Tue, 17 Feb 2015 12:09:04 GMT

Hi Olle,

if your underlying data is already in a proper date number format, you shouldn't need to explicitly timestamp like that, should just be able to floor and date the field.

Date( Floor(SettlementTime), 'DD/MM/YYYY') as SettlementDate

Hope that helps

Joe

Re: Date(floor)

Anonymous — Tue, 17 Feb 2015 12:12:01 GMT

Hi,

Please give space before 'as' keyword:

Date( Floor( Timestamp#(SettlementTime, 'DD/MM/YYYY hh:mm:ss')), 'DD/MM/YYYY') as SettlementDate;

Date( Floor( SettlementTime),'DD/MM/YYYY') as SettlementDate ;

Regards

Neetha