Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ALl,
I have a excel in which the Month names are horizontal and are in text format
I created a cross table and converted to month format .
But still the date is not matching I am not sure the months are created in proper date month format .
Please find the attachment .And let me know if iam doing the right way.
Can please someone sugegst me on this
Thanks
Hi John,
it seems correct.
Month is Dual Field
Min(Month) -> 1
MinString(Month) -> Jan.
Regards,
Antonio
Hi Antonio
Do i need to add the above code in my script or how it is ?
No John,
this is only for test if Month is correctly Dual Field
When i try to include one more table which also has a date format, then this date dont work with that .
What is Your new table and new Format Date ?
The new format of data is coming from Excel which is like
1-Jan-07
.
.
.
.
.
.
.30-Dec-09
Month(Date#(DateField,'DD-MMM-YY')) as Month
Do i need to change the format as
Month(Date#(DateField,'DD-MMM-YY')) as Month
For the month for attached QVW ? or it for the new date
For the new table