Skip to main content
Skip table of contents

ExplodeDates: Explode Date Values into Separate Columns

Tag: ExplodeDates

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

A column must be selected

Tag Attributes

AttributesValue Description
TargetIdentifies the grid by name.
Do not use, or use "grid" for main grid.
No target necessary in sapio365.
ColumnIDColumn 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>


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.