Date format

[#1]

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]

Hi

          Try  the Date() function

Regards

[CELAMBARASAN]

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]

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.