topic Re: Date & Time Field in QlikView

Date & Time Field

Thu, 02 Apr 2015 10:08:40 GMT

How to split my Date into two fields Date and Time field?

Re: Date & Time Field

kiranmanoharrode — Thu, 02 Apr 2015 10:14:49 GMT

Hi Murali,

Use TimeStamp#() function for extracting Date from respective field;

for extracting date:

=Date(TimeStamp#(date,'MM/DD/YYYY HH:MM))

it will extract Date in format defined in 1st main tab of scripting (Default date format for Document)

Further extraction of time use Hour() and Minutes() functions

Regards,

Kiran

Re: Date & Time Field

pokassov — Thu, 02 Apr 2015 10:15:38 GMT

Hi!

date(floor(date))

and

time(frac(date))

Sergey

Re: Date & Time Field

arulsettu — Thu, 02 Apr 2015 10:18:05 GMT

use this to get date

date(date#('03/23/2015 12:03','MM/DD/YYYY HH:MM'))

Re: Date & Time Field

Thu, 02 Apr 2015 10:18:45 GMT

Hi @Murali srithar

Try this code

Load *,

Date#(SubField(STARTDATETIME,' ',1),'DD/MM/YYYY') as Date,

Month(Date#(SubField(STARTDATETIME,' ',1),'DD/MM/YYYY')) as Month,

Time(SubField(STARTDATETIME,' ',2) )as Time;

You can also use combination of timestamp() and date()

Like

date(timestamp(timestamp#(dateFieldName,''M/D/YYYY h:mm))) as NewDate

Re: Date & Time Field

arulsettu — Thu, 02 Apr 2015 10:20:26 GMT

try this for time

=Date(Time#('03/23/2015 12:03','MM/DD/YYYY HH:MM'),'HH:MM')

Re: Date & Time Field

Anonymous — Thu, 02 Apr 2015 10:25:27 GMT

Date Part : DayName(date)

Time Part : date(date,'HH:MM:SS')

if this doesnt work then try this

Date Part : DayName(date#(date,'MM/DD/YYYY HH:MM'))

Time Part : date(date#(date,'MM/DD/YYYY HH:MM'),'HH:MM:SS')

Re: Date & Time Field

Thu, 02 Apr 2015 10:26:42 GMT

Hey Murali,

You can try like this

Table:
Load *,
Date(Floor(Subfield(date, ' ',1)), 'MM/DD/YYYY') as NewDate,
Timestamp(Subfield(date,' ',2),'hh:mm') as Time;
Load * Inline [
date
03/24/2014 12:15
04/22/2014 09:10
];
output:

NewDate	Time
03/24/2014	12:15
04/22/2014	09:10

Re: Date & Time Field

Thu, 02 Apr 2015 11:18:44 GMT

Thanks Uday !!

Re: Date & Time Field

Thu, 02 Apr 2015 13:23:49 GMT

You are welcome Murali