Changing date format from a string

[Anonymous]

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.

[nagaiank · Accepted solution]

The expression

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

gives

Jun-26-2012

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[nagaiank]

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.

[Anonymous]

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.