Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
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??

17 Replies
Not applicable
Author

try this

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

Not applicable
Author

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
Partner
Partner

use Date() function, below is sample

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

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

Sokkorn
Master
Master

Hi Hannan,

Floor(DateField) As Dates -> return 41487


See this and this for details.


Regards,

Sokkorn

Not applicable
Author

Vishwaranjan,

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

Not applicable
Author

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
Master II
Master II

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
Author

try this

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

Sokkorn
Master
Master

Hi Hannan,

That very clear. This one should do your job

Date(Floor(DateField)) As Dates


Regards,

Sokkorn