topic Re: date & time in QlikView

date & time

Anonymous — Sun, 10 Feb 2013 12:52:48 GMT

hi,

i have feild with date & time, like this " DD-MM-YYYY HH:MM:SS"

how can i separate to 2 feilds ,date alone and time alone ?

thanks'

yarin.

Re: date & time

nagaiank — Sun, 10 Feb 2013 13:15:25 GMT

DateField=SubField(DateAndTimeField,' ')

TimeField=SubField(DateAndTimeField,' ',2)

You can format the fields as needed by the application.

Re: date & time

Anonymous — Sun, 10 Feb 2013 13:58:38 GMT

hi,

can you please explain more,tha name of my feild is "start".

i don't know this function and the help (f1) doesn't help.

thanks'

yarin.

Re: date & time

Sun, 10 Feb 2013 14:09:52 GMT

To remove the time and preserve as a date field, assuming your field is called InputDate, use:

Date(Floor(InputDate))

To get just the time, use:

Time(InputDate)

Re: date & time

nagaiank — Sun, 10 Feb 2013 14:18:39 GMT

If the name of your field is 'start', and if you want date alone in a field named 'Date' and time alone in a field names 'Time', use the following expressions.

Date=SubField(start,' ')

Time=SubField(state,' ',2)

The function used is SubField() and the help states the following:

subfield(s, 'delimiter' [ , index ] )

In its three-parameter version, this script function returns a given substring from a larger string s with delimiter

'delimiter'. index is an optional integer denoting which of the substrings should be returned. ....