Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » How do I display MIN date of a field in BIRT(How do I display MIN date of a field)
How do I display MIN date of a field in BIRT [message #1835577] Mon, 07 December 2020 13:27 Go to next message
Nikolai Elders is currently offline Nikolai EldersFriend
Messages: 17
Registered: October 2020
Junior Member

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?

[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 Go to previous message
rbaak Mising name is currently offline rbaak Mising nameFriend
Messages: 31
Registered: July 2009
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.

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:

Current Time: Fri Dec 01 00:52:19 GMT 2023

Powered by FUDForum. Page generated in 0.01931 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top