Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Actually, I need to tranform a string into date for example:
2012_Q1
2012_Q2
2013_Q1
2013_Q2
Until now I only isolated 2012_Q"2" and try to make appear every informations that quarter can show but that way didn't work. Then, do you have a idea to make this string in data?
Regards
The following script gives
Data:
LOAD *,
Date(MakeDate(Left(YYYY_QN,4),(Right(YYYY_QN,1)-1)*3+1,1)) as QStart;
LOAD * Inline [
YYYY_QN
2012_Q1
2012_Q2
2013_Q1
2013_Q2
];
Perhaps like this: makedate(left(YearQuarter,4),right(YearQuarter,1)*3-2)
The following script gives
Data:
LOAD *,
Date(MakeDate(Left(YYYY_QN,4),(Right(YYYY_QN,1)-1)*3+1,1)) as QStart;
LOAD * Inline [
YYYY_QN
2012_Q1
2012_Q2
2013_Q1
2013_Q2
];