You can translate the question and the replies:

Unable to fetch data using date column having date data type

Hi , I have creates a view which consists of a column haviing data type as Date. I am not able to retrieve any data from this view when i am filtering the data based on the date column.
user
13-08-2018 03:11:14 -0400

1 Answer

Hi, I would ensure if the Date value being passed on the filter is in sync with the Source Type Properties of the date column. If required, I would also use TO_DATE and TRUNC functions to convert the filter value to the compatible type. You could refer to the related Q&A [Different Date Formats](https://community.denodo.com/answers/question/details?questionId=90670000000k9kyAAA&title=Different+Date+Formats), [Source Type Properties](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/importing_data_sources_and_creating_base_views/viewing_the_schema_of_a_base_view#source-type-properties) section of the Virtual DataPort Administration Guide, [TRUNC](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/appendix/syntax_of_condition_functions/date_processing_functions#trunc) and [TO_DATE](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/appendix/syntax_of_condition_functions/date_processing_functions#to-date) sections of the Virtual DataPort Developer Guide to get more details. Hope this helps!
Denodo Team
16-08-2018 00:12:36 -0400
You must sign in to add an answer. If you do not have an account, you can register here