Infoview changing date format

[Former Member]

Hi,

I should limit the result of a date object that is shown in my report.

The aim is to change the format from dd/mm/yyyy to mm/yyyy, and avoid the aggregation for day, reducing the lines of the report.

is there any function in Infoview which allow me to create such a variable?

Thanks in advance

Riccardo

[Former Member]

Hi Alan,

the aim is not to transform a date into a string, but to change the format from dd/MM/yyyy to MM/yyyy,

In Web Intelligence INFOVIEW, right clicking in a cell of a table, and selecting "Format Number", I don't have the choice to select MM/yyyy format.

Cheers

Riccardo

[Former Member]

Hi Riccardo,

If you create a variable with the above formula and save it with a dimension qualification, then your table should aggregate to the level of month and year, and thus reduce the number of rows.

If you do not want to reduce the number of rows, but want to display only MM/yyyy I would use an alerter. Set the condition to be [MyDate] Is Not Null and use the above formula as the alert formula.

This will display your data as MM/yyyy but still keep all the records displaying.

Hope I understood your question this time

Regards

Alan

[Former Member]

Hi Riccardo,

you can use

=FormatDate([MyDate];"MM/yyyy")

This will return a string version of the date.

Regards

Alan