You need to sign in to do that
Don't have an account?
Nevin O'Regan 3
Change the date/time format in einstein analytics to date format
Hi guys,
I'm working on Einstein Analytics for the first time and I am struggling with what I would have thought would be a straight forward change. In a table all of my date fields are appearing in Date/Time format e.g. 2018-07-01T00:00:00.000Z. How can I change this to just show DD/MM/yyyy format?
I'm working on Einstein Analytics for the first time and I am struggling with what I would have thought would be a straight forward change. In a table all of my date fields are appearing in Date/Time format e.g. 2018-07-01T00:00:00.000Z. How can I change this to just show DD/MM/yyyy format?
I trust you are doing very well.
You can try this formula:
DateTime Field API : Date_Time__c
Reference: http://www.simplysfdc.com/2018/05/einstein-analytic-convert-datetime.html
Please refer to the below link for common Date challenges in Einstein Analytics:
https://salesforce.quip.com/3XqLASDBb5nE
I hope it helps you.
Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in future.
Thanks and Regards,
Khan Anas
How do I get to the pop up screen that is shown in the link that you shared http://www.simplysfdc.com/2018/05/einstein-analytic-convert-datetime.html? I came across the same blog bu I'm not able to figure out how to navigate to the same pop up that he shows in his example.
I'm faced with the same date/time format issue. Were you able to resolve this? Many thanks in advance!!
You can use this formula
toString(now(), "dd-MM-yyyy")
Reference : - https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_saql.meta/bi_dev_guide_saql/bi_saql_functions_2string.htm (https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_saql.meta/bi_dev_guide_saql/bi_saql_functions_2string.htm)
I hope this helps.