Skip to Content
Author's profile photo Former Member

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.

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      The last example with Output "16/09/2012" shows that months (MM) and minutes (mm) are easily confused.

      Author's profile photo Mahboob Mohammed
      Mahboob Mohammed

      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