How to Make a Grouping in a Report by Date but Without Time?

The 1C:Enterprise developers forum

#1
People who like this:0Yes/0No
Active user
Rating: 6
Joined: Sep 16, 2011
Company: TLG Integration

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?

 
#2
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

For the Date field use the BeginOfPeriod() function with “Day” period (second parameter).

 
#3
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Mar 5, 2012
Company:

you can use format setting in the field parameter. I think it the better way, but not a single alternative method.

 
#4
People who like this:0Yes/0No
Active user
Rating: 6
Joined: Sep 16, 2011
Company: TLG Integration

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.

 
#5
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Nov 1, 2011
Company:

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

 
#6
People who like this:0Yes/0No
Active user
Rating: 6
Joined: Sep 16, 2011
Company: TLG Integration

Correct, George!

 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.