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
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
<ExplodeDates/>
<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>