topic Saparate date and time from field in QlikView

Saparate date and time from field

Anonymous — Thu, 21 Aug 2014 06:08:52 GMT

Hi all..........

My startdatetime is 8/1/2013 0:02 so for that how can i saparate date and time .Please help me.

Re: Saparate date and time from field

PrashantSangle — Thu, 21 Aug 2014 06:11:34 GMT

Hi,

You can use

Date() to get date only

Time() to get time only

Also you can use subfield()

Like Subfield(dateFieldName,' ',1) as Date,

Subfield(dateFieldName,' ',2) as Time,

Regards

Re: Saparate date and time from field

Anonymous — Thu, 21 Aug 2014 06:15:29 GMT

Hi Max..........

Thanx for your answer................Its helpfull for me...........

Re: Saparate date and time from field

sujeetsingh — Thu, 21 Aug 2014 06:18:17 GMT

Date(Startdate,'dd/mm/yyyy') for date and

Time stamp(Startdate,'h:mm:ss[.fff] TT') time

Re: Saparate date and time from field

PrashantSangle — Thu, 21 Aug 2014 06:19:13 GMT

Hi,

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

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

Regards

Re: Saparate date and time from field

CELAMBARASAN — Thu, 21 Aug 2014 06:23:39 GMT

Try this

Simply using Date and Time functions doesn't really split the date and time from a field. It just the changes display value

Date(Floor(startdatetime )) AS StartDate,

Time(Frac(startdatetime )) AS StartTime

Thanks

Re: Saparate date and time from field

Anonymous — Thu, 21 Aug 2014 06:45:04 GMT

Hi..........

Now i got my date as 7/31/2013.When i tried to get the month from my date by following script it gives some error..........

Subfield(STARTDATETIME,' ',1) as myDate,

//Date(STARTDATETIME,'dd/mm/yyyy')as mydate,

month(mydate) as mymonth,

Subfield(STARTDATETIME,' ',2) as mytme,

so for that how can i get month from mydate...................

Re: Saparate date and time from field

Thu, 21 Aug 2014 06:56:55 GMT

Hi Chandani,

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;

Re: Saparate date and time from field

CELAMBARASAN — Thu, 21 Aug 2014 07:07:48 GMT

Hi,

Try with below

LOAD

Date(Floor(startdatetime )) AS StartDate,

Time(Frac(startdatetime )) AS StartTime

Month(startdatetime) AS StartDateMonth; //Preceding Load statement

LOAD

Date(Date#(startdatetime, 'M/D/YYYY H:m')) AS startdatetime

From ...;

Re: Saparate date and time from field

Anonymous — Thu, 21 Aug 2014 07:15:07 GMT

Hi.............

Now i got my exact solution..............