Date equals 'Today' filter for Daily Reports

ERPNext
1

Hi,

Could we have an option for ‘Date = Today’ in filters? The idea is that the date in such a filter would always automatically update to the current date. This way, daily reports (e.g. Daily Sales Register) can easily be created with the report builder by adding such a filter

Thanks

3 Likes
2

use a default:

eg:

{
“fieldname”: “date”,
“default”: date.get_today()
}

3

Hi @max_morais_dmm

Thanks for your response but what I’m asking is for this to be a standard option in the filter when selecting a date field

I’m not sure how your suggested script fits into this

Thanks

4

I agree. We run daily check deposits and we always have to filter to today’s date. Would be great if there was the option to have it always show “Today” whatever that is.

1 Like
5

Hello Wale,
Have you found a way around this?
Thanks.

6

Hi @tiwiex

Nah, not yet

Kind regards,

1 Like
7

@wale i think you’ve to create a query report for this.

8

Try this

tabQuotation.transaction_date=CURDATE()

tabSales Order.transaction_date =CURDATE()

9

Try to use DATE filter with NEXT; select any of week, month…etc