Desktop version

Main > Forum > 1C:Enterprise Platform > 1C:Enterprise – Business applications platform > How to Make a Grouping in a Report by Date but Without Time?

Forum

Search UsersRules
How to Make a Grouping in a Report by Date but Without Time?
Silvia Ashley
#1
Oct 20, 2011 04:06 PM
Active user
Points:: 3
Joined:: Sep 16, 2011

I’ve created a report using the Data Composition Schema which displays documents, the grouping is set by Date field (for example 06/07/2011 11:22, 06/07/2011 11:23 and so on). Please suggest a way to make a grouping which does not care about time?
Profile
Timofey Bugaevsky
#2
Oct 20, 2011 04:32 PM
Guest
Points::
Joined::

For the Date field use the BeginOfPeriod() function with “Day” period (second parameter).
Profile
kwazi
#3
Mar 05, 2012 01:41 AM
Just came
Points:: 0
Joined:: Mar 5, 2012

you can use format setting in the field parameter. I think it the better way, but not a single alternative method.
Profile
Silvia Ashley
#4
Mar 05, 2012 11:42 AM
Active user
Points:: 3
Joined:: Sep 16, 2011

I have tried to set the Format in Appearance property of the Date field in Data Sets tab, but the report was not grouped by this field and I have separate rows for each document. So I have added an additional field to the query due to I need time in this field in another report.
Profile
George Polyakov
#5
Mar 05, 2012 11:27 PM
Just came
Points:: 0
Joined:: Nov 1, 2011

in a query, which is used as a data source for Data Composition Schema, change "Period as Date" field to "BeginOfPeriod(Period,"Day") as Date" field
Profile
Silvia Ashley
#6
Mar 06, 2012 10:44 AM
Active user
Points:: 3
Joined:: Sep 16, 2011

Correct, George!
Profile
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)



© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.