3092698 - Time zone conversion cannot be applied to DATATIME column used in functions to create calculated column in embedded stories

• You can adjust the time zone of DATETIME fields by applying a conversion as per end user's time zone on DATETIME column selected in Query Designer only
• Such time zone conversion cannot be applied to DATATIME column used in functions such as DAY, DATE, MONTH , YEAR while creating a calculated column, which may result in difference in the data
  

  Joining date(UTC) - stored in database	Joining date (IST)- Shown to end user	DAY (Joining date)- Shown to end user
  26 August, 2020, 11:00 pm	27 August, 2020, 04:30 am	27
  26 August, 2020, 08:00 am	26 August, 2020, 01:30 pm	26

SAP SuccessFactors People Analytics

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,  OEM, embed, embedded, SF, SFSF, S4HC, S/4HANA Cloud, timezone, time zone, convert, conversion, formula, calculated, calculation, datetime, date, time, date-time , KBA , LOD-ANA-OEM , Embedded usage of SAP Analytics Cloud , LOD-SF-ANA-SAC , Stories in People Analytics , CA-GTF-SB-S4H-SAC , SAP S4H embedded SAC UI integration , Product Enhancement