Skip to Content

Hi Friends,

In this blog I wanted to show how to convert the date fields as required.

I have a date field data coming from SAP BI BEx Query or Info Provider as 31.07.2012 and so on…

/wp-content/uploads/2012/11/date_159046.png

I want to convert this date into 31/7/2012.

Steps:

1) First check the date field type in webi report.

2) If the date field type is in String format (mostly it will be) then follow the procedure of conversion.

date type.png

3) Create a variable. In that variable, compose a formula as below ( This step is to convert the date field of type “STRING” into “DATE”).

/wp-content/uploads/2012/11/todate_159059.png

4) Now check the result as below.

date conv.png

5) Then create another variable. Compose a formula as below

coverted date.png

6) Now check the final result as below.

final date conv.png

7) If you want to display date as 30/April/2012 then modify the variable created in step 5 as below.

/wp-content/uploads/2012/11/formatdate_159066.png

8) Now check the results as below.

final date conv1.png

Hope it is useful for persons who is looking after such solutions.

Regards

Ram

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply