topic Re: Changing date format from a string in QlikView

Changing date format from a string

Anonymous — Tue, 10 Jul 2012 21:37:58 GMT

Hi,

I have a column in an Excel file called Last_Update. Under that column are a list dates in the format of

2012.06.26 00:47:18

This field is listed as a string.

I want to change the format to 'MMM-DD-YYYY'. Also, out of the list of dates, I would like the most recent date. Thanks.

Re: Changing date format from a string

nagaiank — Tue, 10 Jul 2012 21:44:59 GMT

The expression

Date(Timestamp#('2012.06.26 00:47:18','YYYY.MM.DD hh:mm:ss'),'MMM-DD-YYYY')

gives

Jun-26-2012

Re: Changing date format from a string

Anonymous — Tue, 10 Jul 2012 22:01:54 GMT

If there are several dates, I only want to show the recent date. I tried using the max function, but it did not work. Is there a better way? Thanks

Re: Changing date format from a string

Anonymous — Tue, 10 Jul 2012 22:02:05 GMT

If there are several dates, I only want to show the recent date. I tried using the max function, but it did not work. Is there a better way? Thanks

Re: Changing date format from a string

Anonymous — Tue, 10 Jul 2012 22:02:21 GMT

If there are several dates, I only want to show the recent date. I tried using the max function, but it did not work. Is there a better way? Thanks

Re: Changing date format from a string

nagaiank — Tue, 10 Jul 2012 22:36:09 GMT

It depends on where the date values are. If they are in a table, Max(Date) will select the date. If you post a sample application, I will be able to help further.

Re: Changing date format from a string

Anonymous — Tue, 10 Jul 2012 22:48:25 GMT

Even if I get the Recent Date function to work, I cannot test it as the column in the excel file has only one date for the 15,000 rows. I appreciate your help and will update this discussion on my findings.