Hi,
If you would like to use a WHERE condition with a dynamic rather than static date value, you can specify a combination of functions in the WHERE clause expression.
Upon reading your question, I noticed that you are using Teradata functions. To implement your scenario in Virtual DataPort, you will need to find the Denodo equivalents of those functions.
For example, the WHERE condition equivalent of what you have listed would be:
`WHERE <column_name> = ADDMONTH(ADDDAY(CURRENT_DATE, (EXTRACT(DAY FROM CURRENT_DATE) * -1)), 0)`
Note: The column in your WHERE clause must be of "date" data type. If it is in text format, you can use [TO_LOCALDATE](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/date_processing_functions#to-localdate) to convert it.
You can read the [Teradata SQL to Denodo VQL Quick Reference](https://community.denodo.com/kb/view/document/Teradata%20SQL%20to%20Denodo%20VQL%20Quick%20Reference?category=VQL) Knowledge Base article and the [Datetime Processing Functions](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/date_processing_functions) section of the Virtual DataPort VQL Guide to find all of the Denodo equivalents of Teradata functions and additional information on this topic.
Hope this helps!
