Last 30 day transactions

Question

I am trying to show all transactions for the past 30 days. How can I replicate the following Access desktop expression in Access Web App?

>=Date()-30

Thanks

---

John Fletcher

Answer 1

Use Today() instead of Date()

See https://msdn.microsoft.com/en-us/library/office/jj249622.aspx

---

Regards, Hans Vogelaar (http://www.eileenslounge.com)

Answer 2

That was the first thing I tried. Doesn't work.

---

John Fletcher

Answer 3

In that case, I hope that someone who knows more about Web Apps can help you.

---

Regards, Hans Vogelaar (http://www.eileenslounge.com)

Answer 4

Hi,

Use: Between DateAdd(Day,-30,Today()) And Today() 

Please notice we could not use Arithmetic Operators to calculate date in Access web.