Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try the Date() function
Regards
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
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.