topic Date format in QlikView

Date format

Fri, 17 Feb 2012 06:25:15 GMT

Dear expert

I have a field in a table having date examples:31/01/2011 7:36:46 AM etc....

for the date 31 st itself i have number of data with different time

same way i have date for 30 the january aslo with different time

Now my question is that which function to obtain number days by omitting time

Faisal

Anonymous — Fri, 17 Feb 2012 06:35:03 GMT

Try the Date() function

Regards

CELAMBARASAN — Fri, 17 Feb 2012 07:11:33 GMT

Hi,

If you have a start and end date then use

Interval(enddate-startdate,'D')

use

=Count(Distinct Date(Date))

Hope it helps

Celambarasan

jagan — Fri, 17 Feb 2012 09:35:01 GMT

Hi,

Change the format of the date by using the Date()

Example:

LOAD

Date(DateField, 'MM/DD/YYYY')

FROM DataSource;

Hope this helps you.

Regards,

Jagan.