Eclipse Community Forums: BIRT » How do I display MIN date of a field in BIRT

Help

Home

Home » Archived » BIRT » How do I display MIN date of a field in BIRT(How do I display MIN date of a field)

Show: Today's Messages :: Show Polls :: Message Navigator

How do I display MIN date of a field in BIRT [message #1835577]

Mon, 07 December 2020 13:27

Nikolai Elders

Messages: 17
Registered: October 2020

Junior Member

Hello,

How do I display the MIN date by using an expression builder in BIRT?

I'm trying to display MIN date or the date where the first record was created in a from in BIRT. I've put the required dataset in a field, but I can't find the right expression for it to display the MIN date.

I've tried dataSetRow["registrert dato"] = Number.MIN_VALUE, but it gives me the wrong date.

Any tips for this?

Attachment: expression.png
(Size: 69.15KB, Downloaded 61 times)

[Updated on: Mon, 07 December 2020 13:32]

Report message to a moderator

Re: How do I display MIN date of a field in BIRT [message #1835580 is a reply to message #1835577]

Mon, 07 December 2020 14:46

rbaak Mising name

Messages: 31
Registered: July 2009

Member

You need to use an aggregation to get the MIN date.

Right click in the field you want to add it then choose "insert" find aggregation. Or you can go into your table's data binding and add the aggregation field.

Robert Baakel
https://www.youtube.com/playlist?list=PLht0txJzVxKFp1WRUOouv7rQfkCmLjVas

Report message to a moderator

Previous Topic:	Selecting MIN/MAX date from a Scripted Data source
Next Topic:	Merging Similar Data of multiple rows and showing as one

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 10 08:41:33 GMT 2023

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter