Date range expression in default selection bookmark

[rasmusnielsen]

Hi guys,

I am trying to create a bookmark for default selection when the app opens. I'm using the following expression for my date field which is called [Transaktion Dato]:

=[Transaktion Dato]>=AddMonths(Today(1)-1, -1)

I have a filter pane in my sheet where I can enter the above expression in the filter part. Above expression works as expected but I am trying to change expression to have an upper bound on the dates as well. The following is not working for me:

=[Transaktion Dato]>=AddMonths(Today(1)-1, -1)<Date(Today(1)-1)

I want to limit the selection to the last 30/31 days excluding today as well.

Can anyone tell me how to do this correctly?

[tresesco · Accepted solution]

Try like:

=[Transaktion Dato]>=AddMonths(Today(1)-1, -1) And [Transaktion Dato]<Date(Today(1)-1)

[agigliotti]

you filter expression looks good.

what is your actual result?

[rasmusnielsen]

Thanks, this is exactly what I needed.