Skip to Content
0

how do I convert this into date format. 20090128

Apr 26, 2017 at 12:43 PM

58

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
AMIT KUMAR
Apr 26, 2017 at 02:39 PM
0

use this..

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hey Thanks Amit.

0