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

The 1C:Enterprise developers forum

Pages: 1

Silvia Ashley	#1 People who like this: 0 Yes / 0 No Oct 20, 2011 04:06 PM
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?

Timofey Bugaevsky	#2 People who like this: 0 Yes / 0 No Oct 20, 2011 04:32 PM
Timofey Bugaevsky Guest Joined: Company:	For the Date field use the BeginOfPeriod() function with “Day” period (second parameter).

kwazi	#3 People who like this: 0 Yes / 0 No Mar 05, 2012 01:41 AM
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.

Silvia Ashley	#4 People who like this: 0 Yes / 0 No Mar 05, 2012 11:42 AM
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.

George Polyakov	#5 People who like this: 0 Yes / 0 No Mar 05, 2012 11:27 PM
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

Silvia Ashley	#6 People who like this: 0 Yes / 0 No Mar 06, 2012 10:44 AM
Active user Rating: 6 Joined: Sep 16, 2011 Company: TLG Integration	Correct, George!

Pages: 1

Users browsing this topic (guests: 3, registered: 0, hidden: 0)

/* --- ФИКС ЗАГОЛОВКОВ ДОКУМЕНТАЦИИ (BRUTE FORCE) --- */ /* Цепляемся за все возможные контейнеры Битрикса */ .content h1, #content h1, .workarea h1, .content h2, #content h2, .workarea h2, .content h3, #content h3, .workarea h3, .content h4, #content h4, .workarea h4, .content h5, #content h5, .workarea h5, .content h6, #content h6, .workarea h6 { display: block !important; font-weight: 700 !important; color: #222 !important; text-transform: none !important; margin-top: 1.5em !important; margin-bottom: 0.5em !important; line-height: 1.2 !important; } /* Явно задаем размеры, чтобы перекрыть "font-size: 100%" */ .content h1, #content h1 { font-size: 28px !important; } .content h2, #content h2 { font-size: 24px !important; } .content h3, #content h3 { font-size: 22px !important; } .content h4, #content h4 { font-size: 20px !important; } .content h5, #content h5 { font-size: 18px !important; } /* Ваш случай (5 решеток) */ .content h6, #content h6 { font-size: 16px !important; } /* Если Битрикс или редактор засунули внутрь h5 тег span или font */ .content h5 *, #content h5 *, .workarea h5 * { font-size: inherit !important; color: inherit !important; font-weight: inherit !important; } /* --- СТИЛИЗАЦИЯ ТЕКСТА (Markdown Style) --- */ /* Ссылки в тексте делаем более заметными */ .content a:not([class]) { color: #005aa0; text-decoration: none; border-bottom: 1px solid rgba(0, 90, 160, 0.2); } .content a:not([class]):hover { border-bottom-color: #005aa0; } /* Списки (чтобы не прилипали) */ .content ul, .content ol { margin-bottom: 15px !important; padding-left: 20px !important; } .content li { margin-bottom: 5px !important; }

Download brochures