Skip to Content
avatar image
Former Member

how do I convert this into date format. 20090128

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 26, 2017 at 02:39 PM

    use this..

    =formatdate(todate([Date];"yyyyMMdd");"yyyy/MM/dd")

    Add comment
    10|10000 characters needed characters exceeded