Conversion

[smilingjohn]

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

[antoniotiman]

Hi John,

it seems correct.

Month is Dual Field

Min(Month) -> 1

MinString(Month) -> Jan.

Regards,

Antonio

[smilingjohn]

Hi Antonio

Do i need to add the above code in my script or how it is ?

[antoniotiman]

No John,

this is only for test if Month is correctly Dual Field

[smilingjohn]

When i try to include one more table which also has a date format, then this date dont work with that .

[antoniotiman]

What is Your new table and new Format Date ?

[smilingjohn]

The new format of data is coming from Excel which is like

1-Jan-07

.

.

.

.

.

.

.30-Dec-09

[antoniotiman]

Month(Date#(DateField,'DD-MMM-YY')) as Month

[smilingjohn]

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

[antoniotiman]

For the new table