+ Start a Discussion
Nevin O'Regan 3Nevin 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?
Khan AnasKhan Anas (Salesforce Developers) 
Hi Nevin,

I trust you are doing very well.

You can try this formula:
toDate(Date_Time__c_sec_epoch)

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
Nevin O'Regan 3Nevin O'Regan 3
Hi Khan,

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. 
debikendebiken
Hi Nevin,
I'm faced with the same date/time format issue.  Were you able to resolve this?  Many thanks in advance!!
Shubham Dhupar 8Shubham Dhupar 8
Hi guys
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.