System Date in View?

[AussieCaspio]

Hi All,

I have a table containing Marketing offers, each of which has a start and end date.

Is it possible to create a database view which only lists the offers that are  valid on the current date ?

(I.e offers whos start date <= current date and end date >= current date)

This is for use in a  drop down list, where a paricular offer has to be selected.

Thanks,

Nas

[Vitalikssssss]

Hi @AussieCaspio,

You can create a View which will filter your table with promotion based on start and end date. 

Here is an example of filter:

This article might be useful:  

https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-filter-data/

Regards,

vitalikssssss

[AussieCaspio]

On 3/6/2018 at 9:28 PM, Vitalikssssss said:

Hi @AussieCaspio,

You can create a View which will filter your table with promotion based on start and end date. 

Here is an example of filter:

This article might be useful:  

https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-filter-data/

Regards,

vitalikssssss

Thank you SO much!!!!!