dhis2-users team mailing list archive

["Raminosoa Rabemanantsoa, Tantely" <traminosoa@xxxxxxxxxx>]

DearCommunity,

We are running SQL code to output data from the SQL View module. We get the
following table for an organization unit accross multiple periods
containing results with *startdate* and *enddate*. We have set up the
period to "*Monthly*".

In order to output the Period name (i.e. January 2017 or 201701), shoud we
consider the sartdate or enddate (from period table)? Here in this example,
we could observe the month repeating both for startdate and enddate. In our
understanding, each value for each category should be unique for each
month. Or is there another table containing already the period name that we
have to base the SQL query?


[image: Inline image 1]

Thank you for your support!

Kind Regards,

Tantely.

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*