Date part

[#1]

Hi All,

I have one date field in database in the format of  '30-Jun-14 05.39.00 000000 PM'. Present i need to convert date format as 'MM/DD/YYYY', for this i used "date(DATE_Field,'MM/DD/YYYY') as LOG_DATE".

it's working fine but getting duplicate values (Means same date repeating many times), I want to get only one value for one date.

Please anybody respond me on this requirement.

Thanks,

M V

[ashfaq_haseeb]

Try below

date(floor(DATE_Field),'MM/DD/YYYY') as LOG_DATE

Regards

ASHFAQ

[maxgro]

I suppose you have just formatted your datetime field

If you add a listbox for LOG_DATE and format with some decimals (in number tab) I think you see many values for the same date.

Maybe the little example in the attachment can help you