topic Re: Date part in QlikView

Date part

Mon, 30 Jun 2014 11:05:41 GMT

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

Re: Date part

ashfaq_haseeb — Mon, 30 Jun 2014 11:14:55 GMT

Try below

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

Regards

ASHFAQ

Re: Date part

maxgro — Mon, 30 Jun 2014 11:17:02 GMT

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