its worked Thanks a lot
You are welcome.
Hi Kumar & SHINICHIRO MURAKAMI,
i need small clarification as per Kumar data month is "September" but when i have used the date(dateparse("yyyymmdd",str([field name]))) calculation in tableau it displaying as below way
In Place of Month January is displaying should be display as September right? kindly have a look in to that let me know if my understanding is wrong
And One more clarification i need i import the raw data in to tableau through Excel option in connection window "Data of " field data type is "Number" when i change the datatype to "Date" values are displaying as "NULL" have a look on below snap shot why it's changing as Null.if you have idea let me know.
I'm sorry I made easy mistake.
It should be
The date and number is completely different thing.
Similar as Excel, 2016/9/1 = 42612.