I uninstalled the old 9.3 version and re-downloaded the current version which is 10.0
The issue didn't go away.
I tested by introducing a new field copied from the original timestamp but took only date part, i.e. instead of 01/Jul/1995:00:00:01, the new field shows 01/Jul/1995, save it as csv
I added the new csv as data source and applied the same formula to the new field, Tableau cannot calculate it correctly neither.
So what's wrong with this?
Am I missing anything? Can anyone help please? Thanks lots in advance.
Hi Raymond, your date format ('01/Jul/1995:00:00:01') looks like a date, not a date format. You might find knowledgebase article helpful: Understanding the DATEPARSE Function | Tableau Software
Also see the information about "locale considerations": the result from DATEPARSE might depend on your machine locale (and could explain why it works for someone else but not for you).
It turns out to be locale issue, after I reset the region of my computer to USA, everything works as expected.
Further to Jeff's post;
Your first post contains the correct formula/function - dateparse('dd/MMM/yyyy:HH:mm:ss',[Timestamp])
Your second post has an invalid dateparse string, you're writing the actual date itself.
I've connected to your file and I can confirm it works fine for me so as per jeffs suggestion, it's likely something with your locale settings.
Perhaps you could try force it into a date a different way - datetime(left([Timestamp],11) + ' ' + right([Timestamp],8))
Thanks Tom, second post was to show the troubleshooting. It is something Tableau recognized and is on its schedule to deal with issues like this that actually caused by region setting.
Here is more details: https://community.tableau.com/thread/158230?start=0&tstart=0