Changing to current date automatically

Question

Hi all, 
 
 I am new to appian and I am trying to build a to-do list, in which the list automatically updates the date to today in the interface, and from the database queries all the to activities for today as well as yesterday. 
 So, I was able to make the date field dynamic in the interface layout, therefore unable to retrieve the data from the database corresponding to of current date. In the SQL, still I can manage to check the current date, but how can I update the date field in the interface layout to show todays date as my column header.

Peter Lewis · Answer

The best way to approach this is to set up a local variable that contains the current date. You can set a default value for the local variable of today, but the variable can still be changed using a date field. Plus, you can use the current value of the variable to return the current list of activities for today. 
 Here's an example: 
 a!localVariables(
 local!date: today(),
 local!query: {}, /* rule!GetDataByDate(local!date) */
 {
 a!dateField(
 label: "Date",
 value: local!date,
 saveInto: local!date
 ),
 a!sectionLayout(
 contents: {
 a!richTextDisplayField(
 value: a!richTextItem(
 text: /* Display the results of local!query here */
 "Here's the results for " & local!date,
 size: "LARGE"
 )
 )
 }
 )
 }
)