Hi Durai,
There is the rtt function which converts a non UTC timestamp (seconds since 1/1/0000) to a nicely formatted time string. However this is not applicable here since it ignores timezones (it assumes your timestamp is in the same timezone as you).
I would recommend creating a custom script in DIAdem, which you run once before creating the report. See below an example script to read the custom property and create a new property with the local time string in Python. The script has access to all channel groups / channels that are loaded into your data portal (called "Root" in the script). Make sure to load all relevant channel groups / channels so the script can find them.
from datetime import datetime, timezone
from DIAdem import Application as dd
GROUP_NAME = "group_name" # select which group to act on
PROP_NAME = "prop_name" # specify property name containing timestamp
for channel in dd.Data.Root.ChannelGroups(GROUP_NAME).Channels:
if channel.Properties.Exists(PROP_NAME):
prop = channel.Properties(PROP_NAME)
utc_dt = datetime.fromtimestamp(prop.Value, tz=timezone.utc)
local_dt = utc_dt.astimezone()
local_str = local_dt.strftime('%Y-%m-%d %H:%M:%S %Z')
# this will add the new custom property called
# LocalTime with the local time string as value
channel.Properties.Add("LocalTime", local_str)
Let me know if it helps, or if you have more questions!
Best regards
Leonard
