Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ALL,
How do i create another field of ABC
DATE (datedoftssb,'DD-MM-YY') as ABC
with Month only in the same table without have to reextract all again in another qvw.
As far as i know i need to use this
Month(Date#(ABC, 'DD MMM YYYY')) as Month.
Kindly advice.
Thanks.
You can use:
Month(DATE (datedoftssb,'DD-MM-YY')) as Month,
tq...
You're welcome.
Another option is to use a Preceding Load, like this:
Load
*,
Month(ABC) as Month;
Load
DATE (datedoftssb,'DD-MM-YY') as ABC
FIELD2,
FIELD3,
etc
FROM SOURCE;