I'm was looking at the help file for a way to find out the quarter from a date, and this is what i found.
[quote]Q outputs the quarter of the year as a number from 1 through 4.[/quote]
So in the transformer i used this logic to get the quarter:
[code]Oconv(Iconv(LP_POLICY_SALES.LedgerDate,"D2-")," DQ")[/code]
Ledger Date is coming in as : "31-AUG-07" that is why i used the iconv.
When using that logic that value i'm getting is: LEDGER_QUARTER = 14488
How can i correct this?
Quarter Function
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: