Show content of field in tabel for specific day

[jamesehunt]

Hi all,

I have the following issue.

I want to create a tabel, which should look like this:

Date	User	RF Gun
Today()-1 or max(date)	JSHUNT	BER01MDS01
Today()-1 or max(date)	MAMUELLER	BER01MDS02
Today()-1 or max(date)	MAMUELLER	BER01MDS03

I only want to see the latest date and not all dates.

Is it possible to do this without editing the script?

[jamesehunt · Accepted solution]

=if(date >= today()-1 and date <= today(), date(date), null())