Skip to Content
Author's profile photo Former Member
Former Member
November 23, 2012 1 minute read

Convert Date field as required in webi

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

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.