Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Plz help me arrange date in order Year, Month. Find attached
Regards
Ema
Year and Month calculation section need to be corrected as below..
Year(Date#(TRIM(Date_promoted),'MMM D YYYY'))
and
Month(Date#(TRIM(Date_promoted),'MMM D YYYY'))
Hi,
=Date(Date#(Date_promoted,'MMM DD YYYY'),'YYYY/MMM')
hope this helps
regards
Marco
Hello Macro,
This helped alittle but worked for only promoted, how do i resolve the rest in the container?
Help
Hi,
this solution can be adapted to your other Timestamp fields as well:
hope this helps
regards
Marco
Hi Ema,
I noticed that you don't close your threads.
Please do so to help increase the readability and searchability of this forum.
Thanks
regards
Marco
Hi,
did you check my reply here
http://community.qlik.com/thread/138053
Please don't post multiple threads.
and please close threads if you get required output.
Regards
ASHFAQ
Marco,
Plz remove snapshot.
Thanks
Emma,
Plz close your threads.
Thanks
Hello Macro,
i have plz remove pix