Tag: ExplodeDates
The ExplodeDates function expands (or explodes) dates in the grid.
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