Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quickbase University
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Posts
All Communities
My Communities
Getting Started
Events
Qrew Groups
Discussions
View Only
Community Home
Discussion
64.7K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
Date filter start on current day
Aaron Zielinski
06-05-2017 16:29
I have a couple of filters on the left side of my report screen. The first one is "Date" as the report ...
QuickBaseCoach Dev./Training
06-05-2017 16:44
No problem. I suggest that you make a new field called [Today?]. Make it a formula field with the ...
1.
Date filter start on current day
1
Like
Aaron Zielinski
Posted 06-05-2017 16:29
Reply
Reply Privately
Options Dropdown
I have a couple of filters on the left side of my report screen. The first one is "Date" as the report is a list of timecards. The "Start Date" defaults to the record (timesheet) that is the earliest in the system. Is there a way to have the "Start Date" filter default to the current day so that users do not have to change the date from a previous year every time they filter?
I do need the ability to filter for all dates from the filter so I don't want to hard code a start date that can't be manually changed (in the pop out calendar) while filtering. Thanks in advance!
Aaron
2.
RE: Date filter start on current day
0
Like
QuickBaseCoach Dev./Training
Posted 06-05-2017 16:44
Reply
Reply Privately
Options Dropdown
No problem.
I suggest that you make a new field called [Today?]. Make it a formula field with the formula of
IF([my date field]=Today(), " Yes, no")
Then include that field as a Dynamic filter on the report.
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Copyright . All rights reserved.
Powered by Higher Logic