Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Date Format Issue

Hey,

I have date in the following format including time stamp.

29/09/2013 09:15

When I load this date field in qvw file it is represented in the following format

41487.4638888889

I want to separate time stamp and date in order to use only date as dimension.

any ideas??

Tags (2)
17 Replies
Not applicable

Re: Date Format Issue

try this

date(date#(fieldname,'DD/MM/YYYY hh:mm'),'DD/MM/YYYY hh:mm')

Not applicable

Re: Date Format Issue

hi

try this

in script-

Date(Date#(datefieldname,'DD/MM/YYYY hh:mm'),'DD/MM/YYYY hh:mm') as datefield


example--

in text box

=Date(Date#('29/09/2013 09:15','DD/MM/YYYY hh:mm'),'DD/MM/YYYY hh:mm')

manojkulkarni
Valued Contributor II

Re: Date Format Issue

use Date() function, below is sample

Date(datefield,'DD-MM-YYYY') for date

Date(datefield,'hh:mm') for timestamp

Sokkorn
Honored Contributor

Re: Date Format Issue

Hi Hannan,

Floor(DateField) As Dates -> return 41487


See this and this for details.


Regards,

Sokkorn

Not applicable

Re: Date Format Issue

Vishwaranjan,

I want to remove the time stamp from the date preserving the actual date ..  I dont want timestamp in my date.

Not applicable

Re: Date Format Issue

I have date like this in excel file

29/09/2013 09:15

and when excel file is Loaded in the qvw it shows

41487.4638888889


I want to remove time stamp from my date.

I have this '29/09/2013 09:15'

I want this '29/09/2013' in my qvw.


er_mohit
Honored Contributor II

Re: Date Format Issue

Try this

date(date#(fieldname,'DD/MM/YYYY hh:mm'),'DD/MM/YYYY') as Date,

time(time#(fieldname,'DD/MM/YYYY hh:mm'),'hh:mm') as Time

Not applicable

Re: Date Format Issue

try this

Date(Date#(datefieldname,'DD/MM/YYYY hh:mm'),'DD/MM/YYYY') as datefield

Sokkorn
Honored Contributor

Re: Date Format Issue

Hi Hannan,

That very clear. This one should do your job

Date(Floor(DateField)) As Dates


Regards,

Sokkorn

Community Browser