Any tutorials on :

- Filtering a recordset by current date
- Styling a table row based on current date

Can't seem to find anything on using the current date to display specific data or classes with latest extensions

Hi Brad,
Yes there is a tutorial showing how to filter a query by current date: www.dmxzone.com/go/32650/filtering-a-query-by-date-range-with-server-data-formatter/
As for table row styling - what exactly do you need to achieve?

Thanks Teodor,

I'll look at the tutorial. As for the row styling basically I need to style the row to 'danger' of the date in the record is past, 'success' if it is todays date ..... I know how to style the row based on other expressions but just can't figure out how to do it with the current date.

Hi Brad,
In App Connect, add new Component > Data > Date And Time - this var returns the current date.

Then in the App Connect formatter, select your database date, apply days until formatter, and select this date and time variable as a value to compare.
Then with the operation filters, just adjust add "<" with the required number of days as a value.

That didn't work, it styled all of the rows regardless. However, I do like that Date and Time Variable!

Hello Brad,
What exactly did you add, that didn't work? Can you provide a link to your page?