Jump to content

BIRT Developer Center Download


Photo
- - - - -

parameter date shows wrong, calculations are correct in spreadsheet

parameter date timezone excel

  • Please log in to reply
2 replies to this topic

#1 ym2016

ym2016

    Newbie

  • Members
  • Pip
  • 5 posts

Posted 15 September 2016 - 02:10 AM

Hi,

 

I have a Birt report that makes dates calculations depending on a escalar parameter that the user chooses.

The problem: the date appears as in USA timezone, so the 1st of June 2016 appears as the 6th of January 2016.

 

That is the only problem, because all the calculations are correct, later on. In the scalar parameter, I have set up the way it should display, but the screen does show a very different format, I really don't know what to do,

 

Could you please help me? When I send my reports to production, I only send the rptdesign file, so it is in this file that I should be able to fix the issue. I cannot ask to change the timezone of the server either.

 

Here is the code of the scalar parameter:

 

<scalar-parameter name="init_date" id="3318">
                    <property name="valueType">dynamic</property>
                    <property name="isRequired">true</property>
                    <property name="dataSetName">exceluserCSV2</property>
                    <expression name="valueExpr">row["INIT_DATE"]</expression>
                    <expression name="labelExpr">row["INIT_DATE"]</expression>
                    <property name="dataType">date</property>
                    <property name="controlType">list-box</property>
                    <property name="fixedOrder">true</property>
                    <structure name="format">
                        <property name="category">Custom</property>
                        <property name="pattern">dd/MM/yyyy</property>
                    </structure>
                </scalar-parameter>

 

this is how the date 01/06/2016 displays in the screen where you choose the value of the parameter Jan 6, 2016

 

Thanks for all your help and support.



#2 ym2016

ym2016

    Newbie

  • Members
  • Pip
  • 5 posts

Posted 16 September 2016 - 01:34 AM

After re-testing the report, not only the display is wrong. Calculations are wrong as well.

 

Any help is welcome.



#3 SailRCG

SailRCG

    Junior Member

  • Members
  • PipPipPip
  • 56 posts

Posted 12 December 2016 - 12:04 PM

If you have an example rptdesign. I can give it a look...   I have had a similar problem I referred to as "Crazy Date Math" it was a common formatting problem