sql function in Table Filter and Charts

[Lakshmi S]

Hi Team,

 We have a requirement to show in the table "the Week-Beginning Monday Date in the table should extend in perpetuity and only show the most recent week-beginning day, which is 08/07/2023."

We are looking into this documentation.
https://docs.stiltsoft.com/tfac/dc-server/general-syntax-and-sql-functions-available-42246251.html

Do you have any suggestions for how I can accomplish this?

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Lakshmi S,

You can set the following dynamic time interval format in the Table Filter macro: weekstart

But note that filtration will work starting with Monday in case of using English(UK) language instead of, for example, English (US) in Profile (find more details here).