Discussion board where members can get started with QlikView.
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
Try the Date() function
If you have a start and end date then use
Hope it helps
Change the format of the date by using the Date()
Hope this helps you.