how to get quarter date format

[pxraja]

Hi all,

I want to get the quarter format like

for the input link

Inlink.field1 Inlink.field2
5848 May 08
5848 July 08

Outlink.field1 Outlink.field2
5848 2008Q2 for 2nd quarter
5848 2008Q3 for 3rd quarter

I tried for Oconv(Iconv(Inlink.field2,'D MY[A3,2]'),'DQYQ')

It's giving me result what I am not expecting (obivously, its returning again quarter value)

but how to get Q inserted inbetween year and quarter

any ideas are welcomed

[ArndW]

StageVar: InternalDate = ICONV(Inlink.field2,'D MY[A3,2]')
Derivation: OCONV(InternalDate,'D4Y'):'Q':OCONV(InternalDate,'DQ')

[chulett]

but how to get Q inserted inbetween year and quarter

In other words, you need to handle the 'Q' and insert it between the two other elements.

[ray.wurlod]

Simply apply the QUARTER.TAG transform. This gives yyyyQn (a standard format specified in ISO 8601).

If you require nQyyyy then something like the following will do it.

Code: Select all

Oconv(Iconv(InLink.TheDate,"DMY[A3,2]"),"DQY['Q']")

Or, if you require a two-digit year, the following.

Code: Select all

Oconv(Iconv(InLink.TheDate,"DMY[A3,2]"),"D2QY['Q']")

[chulett]

Or that.

[pxraja]

StageVar: InternalDate = ICONV(Inlink.field2,'D MY[A3,2]')
Derivation: OCONV(InternalDate,'D4Y'):'Q':OCONV(InternalDate,'DQ') ...

Hi all,

Thanks for your ideas, either of two is working fine, QUARTER.TAG and the above quotes has resolved

[truenorth]

I am facing the same situation here. I have a date type field. What is the syntax for QUARTER.TAG? Is it expecting a date type or internal? I am currently running a server job and the first lines in the job log in Director is a warning that QUARTER.TAG was passed a non-numeric value. Will the job still finish with the correct results?

Is there any way to pull this off in a parallel job? I tried using QUARTER.TAG, but got an error as soon as I entered it in Transformer.

Again, I have a date field. And I want to get the year and quarter in this format: 2010Q1

And I prefer to do everything in a parallel job rather than a server one.

Thanks in advance.

[chulett]

You need to start your own post over in the PX / Enterprise Edition forum.

[Vineet Pal Singh]

Oconv(Iconv(ASOF_DT[1,10] ,"D-YMD[4,2,2]"),"DQ")