ExplodeDates: Explode Date Values into Separate Columns

Tag: ExplodeDates

The ExplodeDates function expands (or explodes) dates in the grid.

ribbon menu explode cells.png

right click explode selected multivalues.png

A column must be selected

Tag Attributes

Attributes	Value Description
Target	Identifies the grid by name. Do not use, or use "grid" for main grid. No target necessary in sapio365.
ColumnID	Column UID shows the columns that aren't visible - selects the column like <SelectColumn ColumnID="..."/>

Example Scripts

XML

<ExplodeDates/>

XML

<ytriaAutomation>
	<ShowMyDataMail>
		<Select Lines="ByValue">
			<SetParam ColumnID="senderName" Value="Alex Wilber"/>
		</Select>
		<SelectColumn ColumnID="toRecipientsAddresses"/>
		<ExplodeMultivalues/>
		<!--SelectColumn ColumnID="receivedDateTime"/-->
		<ExplodeDates columnID="toRecipientsAddresses"/>
		<ExplodeTimes/>
		<Export>
			<SetParam Field="FileOutput" Value="ASCII"/>
			<SetParam Field="Mode" Value="Create"/>
			<SetParam Field="ExportType" Value="HTML"/>
			<SetParam Field="ChildrenOnly" Value="False"/>
			<SetParam Field="ExpandAllGroups" Value="False"/>
			<SetParam Field="OpenFileOnceGenerated" Value="True"/>
			<SetParam Field="SelectedRowsOnly" Value="True"/>
			<SetParam Field="ExcelSheetName" Value=""/>
			<SetParam Field="ExcelTemplate" Value=""/>
			<SetParam Field="FilePath" Value="AlexWilberMails-Exploded"/>
		</Export>
		<ImplodeAllDateTimes/>
		<ImplodeAllMultivalues/>
	</ShowMyDataMail>
</ytriaAutomation>