Skip to Content

FormatDate function with different Parameters in Web Intelligence 4.0

Formatdate() function got various parameters which can helps us in avoiding replacement path in BEx queries to get date related values like Month Name, Number etc. in Column names.

You can find list of parameters and output in below snapshot. These parameters are not documented in user guides.

Format Date-Parameters.jpg

Hope this information is helpful.

2 Comments
You must be Logged on to comment or reply to a post.
  • Hi Ambreen,

     

    The formula in the last row should be updated as:

    =FormatDate(CurrentDate();”dd/Mm/yyyy hh:mm:ss a“)

     

    “Mm” is the correct syntax to get Month number and “a” gives us whether the time is “am/pm.”

     

    Thanks,

    Mahboob Mohammed