Jump to content
  • 0
Sign in to follow this  
AussieCaspio

System Date in View?

Question

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

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0
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:

Screenshot.JPG

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!!!!! 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×