Web-i Custom Number Format Document

[Former Member]

I am trying to configure a date to show in a specific format (i.e. MM/DD instead of something else). I realise that I could create new variables (formatdate function)...but this is time consuming as I have many date objects.

Does anyone know of any documentation for using the 'Format Number'> New Custom Format for dates?

If not, how can I have my date/time display as dd-mm HH:mm ?

Tjamls

[Former Member · Accepted solution]

Hi Joe,

You cant define DATE syntax in format-number. Instead right click on DATE column, go to format-number -- date/time --- custom and add the following.

Observe below screenshot.

Now all dates will be in DD/MM/YYYY HH:MI:SS format.

Regards,

G Sujitha

[Former Member · Accepted solution]

My thanks Sjitha; do you know if there is any documentation on all of these possible formats for date?

[Former Member · Accepted solution]

Hi Joe,

Find the below links. It may help you.

http://ibusinessintelligence.wordpress.com/2012/11/02/bo-webi-date-format/

Custom date and time formats for the Format function (Access 2013 custom web app)