Jump to content
  • 0
Sign in to follow this  

System Date in View?


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.



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:


This article might be useful:  




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