Skip to Content
Author's profile photo Former Member
Former Member
October 24, 2013 Less than a 1 minute read

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 M Mohammed
      M 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