Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a date variable 'Start_Date) which is formatted as DD/MM/YYYY.
Within my Line chart in my dimension, I have amended the date format to show MM YYYY:
=Date(Start_date(Date#(call_date,'DD/MM/YYYY')),'MM YYYY')
However, my line chart still shows the date as DD/MM/YYYY within the X axis, any idea how to show as MM YYYY please?
Hi
Try this
Variable start_date = Date(Date#(call_date,'DD/MM/YYYY'),'DD/MM/YYYY')
In dimension Date($(start_date ),'MM YYYY')
or
In dimension Date(Date#(call_date,'DD/MM/YYYY'),'MM YYYY')
Hope this helps
Thanks
Hi
Try this
Variable start_date = Date(Date#(call_date,'DD/MM/YYYY'),'DD/MM/YYYY')
In dimension Date($(start_date ),'MM YYYY')
or
In dimension Date(Date#(call_date,'DD/MM/YYYY'),'MM YYYY')
Hope this helps
Thanks