Could Any One create Master Calander for it. i tried it but after apply the calander my date field is empty.
is there any other way to create calander .
Looks like the format of Date is different in your excel file.
Please provide your excel file here.
could u please see in new post i attached the excel file there.
Seems like you were forcing QV to read Order_Date as MMDDYYYY (by using the Date#() function when in fact it was MM/DD/YYYY
Retrieving data ...