This content has been marked as final.
Show 2 replies
-
1. Re: Changing a date string to a date part
Elvis Has Left The Building Nov 15, 2012 6:52 PM (in response to Michele Fork)Michele, I'm fairly certain Jonathan Drummey posted a solution similar to this about six months ago. He might be able to help you.
-
2. Re: Changing a date string to a date part
Tracy RodgersNov 19, 2012 10:24 AM (in response to Michele Fork)
Hi Michele,
One way to do this is to create a calculated field similar to the following:
if left([Date], 1)='1' then date('1/1/20' + right([Date], 2))
elseif left([Date], 1)='2' then date('4/1/20' + right([Date], 2))
elseif left([Date], 1)='3' then date('7/1/20' + right([Date], 2))
elseif left([Date], 1)='4' then date('10/1/20' + right([Date], 2))
end
Then, if you'd like to change the format, right click on it and select Format. Under Dates, choose Custom and type in the following to get a similar output as what's in your data:
\Qq yyyy
Hope this helps!
-Tracy