on 04-26-2017 1:43 PM
I am nnew to web Intelligence.My data in the column is 20090128
2009 is year
01 is month
28 is day
so how do I convert this into 2009/01/28.
Thanks for the help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
use this..
=formatdate(todate([Date];"yyyyMMdd");"yyyy/MM/dd")
Hey Thanks Amit.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.