Query by id and date1-date2

suryadi

Dear all,

I need a dialog for the user can enter or select one ID and put a period (date1 until date2), then the process query with that parameter and display the data. My data is tnc.xlsx
Why I can not read tnc.csv correctly? So I save it into tnc.xlsx and use read xls file.

Thank you very much in advance.

Warmest Regards,
Suryadi

kayman

Hard to say without knowing how the csv is structured versus the xlsx. 

A lot of things can go wrong while importing what seams a valid csv, from picking the wrong column separator (are you using a simple space, a comma, a semi-column, a tab or even something else), to enabling/disabling the quote characters and so on.
With xls all of these are basically already covered by the format, so you have far less impact yourself. Personally that's why I prefer xls over csv but that's not always an option of course.

Did you try to use the import wizard when using the csv? This usually tells you pretty quickly where you are overlooking something.