My Stuff
Avatar
See All the Unlockable Badges See All the Unlockable Badges

Bee Yook Blue Ribbon

Comments

  • @ Kristoffer Viray-Oracle , Thank you to you too . I just noticed after 3pm (malaysia time), Pacific time is 12am, the trend graph show the figure for 24 Mar 2022 (today), i guess this is time zone issue.. is anyone know where i can set for this time zone for trend graph ? currently, we set our time zone as (GMT+0:00)…
    in Trend Graph (daily) in dashboard Comment by Bee Yook Mar 24, 2022 7:36AM
  • Dear Mikko, Thanks for your valuable advice. Yes, i tried below command but it's still didnt shown malaysia time. TO_CHAR(TO_TIMESTAMP_TZ(TO_CHAR({createddate},'MM/DD/YYYY HH24:MI:SS'), 'MM/DD/YYYY HH24:MI:SS TZH'), 'MM/DD/YYYY HH24:MI:SS TZH:TZM') Could you please advise what will be the correct formula for this…
    in AE:How to convert GMT to Malaysia time zone Comment by Bee Yook Dec 7, 2021 7:06AM
  • Dear Ivy, Thank you so much for your hints. Yes, you are right, found there are records with WSA-20210326A20210327 instead of WSA-20210326-20210327.. that cause the error.. Once again, thank you very much.. it really helped. Kind regards, Bee Yook
    in Convert String to date in saved search Comment by Bee Yook Nov 10, 2021 5:37AM
  • Dear Ivy, Thank you for your quick replied. For Formula(Text), it working fine. However Formula(date), it shown the following error or as attached: "An unexpected error has occurred. Please click here to notify support and provide your contact information." Yes, you are right, the actual fieldname is "inventorynumber".…
    in Convert String to date in saved search Comment by Bee Yook Nov 10, 2021 2:23AM