Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Date format

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

3 Replies
chandashok
Not applicable

Date format

Hi

          Try  the Date() function

Regards

celambarasan
Not applicable

Date format

Hi,

     If you have a start and end date then use

     Interval(enddate-startdate,'D')

     Or

     use

     =Count(Distinct Date(Date))

Hope it helps

Celambarasan

jagan
Not applicable

Date format

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.