Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have imported the data from Teradata table which has a date field in MM-DD-YYYY format, I am building a chart where this field is in X axis , I want the format to be changed to MM-YYYY.
Please let me know if any one knows about it.
Thanks
Hi
Use the expression as MonthName(ReadingDate) u willl get as Dec 2013
or using Date(Readingdate,'MM-YYYY') As Date either in script or in the expression of the list box.
If this doesnt work upload a sample file
Thanks
Try something like this.. date(DateField,'MM-YYYY')
Ex: date(today(),'MM-YYYY')
Thanks, I got it.
If you got the solution from the posts, please mark the answer as correct..
So that new bees can access solution easily...
Hi Nasir,
You below expression, use MonthEnd() or MonthStart() to avoid the duplicate month names
=Date(MonthEnd(DateField),'MM-YYYY')
Hope this helps you.
Regards,
Jagan.
Well , the solution for this problem is :
1. go to edit script and upload the data from your QVD file
2. write the code like an SQL statement with the date variable.
For eg:
Load
Date(Date,'MM-YYYY')as Mon_YYYY
from C:\Users\ndurani\desktop\abc.qvd(QVD);
Once the data is uploaded, you can go to the main sheet and build the graph with new chart object.
hi
try this
date(date#(fieldname,'DD-MM-YYYY'),'MM-YYYY')
Regards