Show today's values

Ask the community
,
1

hello - I have a database that includes dates and people’s names. I’m trying to display the values for “today” so that each day users can see who is on call. How can I make a table that defaults to filter to today’s date? Or create a box to show what values from the database correspond to today;s date? thanks!

2

This gets the today date in a format you want.

var today = new Date();
var dd = today.getDate();
var mm = today.getMonth()+1; //January is 0!
var yyyy = today.getFullYear();
if(dd<10) {    
    dd = '0'+dd
} 
if(mm<10) {
    mm = '0'+mm
} 
today = mm + '/' + dd + '/' + yyyy;
console.log(today);

Then you can use that date to set a filter on your Data Collection just make sure it uses the same format in your Data Collection as you create in the code above.

3

Thank you very much! And then how do I set the filter? Sorry I am very much a beginner :frowning: