Smartstaff, administrator
4,478
edits
Changes
no edit summary
{{SeqReportPageHeader}}
You will sometimes need to create reports that use the current year, month, or day. To build these types of criteria, you will need to use the Date/Time Translation setting, in conjunction with special criteria that retrieve the current date in a specified format.
1. Copy [[Accessing Reports in SmartSimple|Edit your report]] from the Reports window by clicking the report '''Employee Start Dates''' to a new report''' Employee Start Dates - Current Year'''Edit Report icon ({{EditIcon}}).
[[Image:Reps58ReportListViews.png|link=|800px]]
2. Display the '''Report Builder'''.
3. Click the '''Date ComparisonsComparison''' tab in the '''bottom half''' of the windowReport Builder Help section.
[[Image:Reps59ReportBuilderHelp-DateComparison.png|link=]]
These expressions are used in the criteria to automatically display dates
[[Category:Reports]]
In order to return only records from today's date, enter the following MySQL command into the criteria field: '''=curdate()''', as follows:
[[Image:Todaysdateinreportbuilder.jpg]]
{{PrevNextStart}} [[Using a Date Range in a Report]]
{{PrevNextMid}} [[Creating Summary Reports]] {{PrevNextEnd}}
[[Category:Date Formats]]