heathb
02-08-2017, 06:16 AM
Hi all..
Am having a lot of trouble trying to format a field containing the following (as an example "2014-09-01T13:58:04Z" ) into a date.
A couple of examples below. I always get the date "01/10/2014" however excel does not recognise this as a date when filtering etc. I have about 50k rows to update and would rather not do this manually.
All help appreciated
=RIGHT(LEFT(CY5,10),2)&"/"&RIGHT(LEFT(CY5,7),2)&"/"&LEFT(CY5,4)[/TD]
[CODE]=TEXT(LEFT(CY7,10),"dd/mm/yyyy")[CODE]
thanks
Am having a lot of trouble trying to format a field containing the following (as an example "2014-09-01T13:58:04Z" ) into a date.
A couple of examples below. I always get the date "01/10/2014" however excel does not recognise this as a date when filtering etc. I have about 50k rows to update and would rather not do this manually.
All help appreciated
=RIGHT(LEFT(CY5,10),2)&"/"&RIGHT(LEFT(CY5,7),2)&"/"&LEFT(CY5,4)[/TD]
[CODE]=TEXT(LEFT(CY7,10),"dd/mm/yyyy")[CODE]
thanks