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.

To report this post you need to login first.

2 Comments

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

  1. 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

    (0) 

Leave a Reply