Explode Dates

Tag: ExplodeDates

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

<ExplodeDates/>

XML

Tag Attributes

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

A column must be selected.

Example Script

<ytriaAutomation Application="sapio365">
	<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>

XML