DateTime fields in BI Publisher Excel Templates
Bringing in Date-time fields into BI Publisher Excel templates can be challenging. Just placing them in our template results in a text field unusable by Excel as any kind of date or time and hard for the user to understand in a list of similar values.
We'll demonstrate how to bring in Date-time fields from the XML file and convert it to an Excel Date-time format to make it more readable for your users and manipulable through Excel for date-time math and formats.
PeopleTools Tech Tips: https://peopletoolstechtips.com/forma...
Buy me a Ko-Fi and support my OCI server habit: https://ko-fi.com/peopletoolstechtips
Production Notes:
A PT3 Production
Presenter: Randall Groncki
Camera Kid: Anjelica Groncki
Music: Vlad Gluschenko — Overseas
License: CC BY 3.0: https://creativecommons.org/licenses/...
/ @vladgluschenkomusic