Ninox Database 2 5 8 X 2

• Ninox Database For Pc
• Ninox Database 2 5 8 X 2 3
• Ninox Database 2 5 8 X 2 4
• 2 5/8 Ruler

How can I use the SELECT command to get the most recent record with a date field ?

Ninox Database 2.5.8 MAS + iCloud. Categories: Software » Mac. Compatibility: macOS 10.10 or later, 64bit. Ninox is an easy to use database app for Mac & iOS. Apple magic keyboard space grey review. Ninox DB allows businesses to build custom database apps and offers Mac, iPad, iPhone and web apps. It makes it easier for users to get started and build powerful DB apps in less time. It allows even the not-so-technical users to quickly start building database apps using the ready-made templates, which are designed to make life easier.

Like 'q := SELECT Table where Date < myDate' but limit to 1 result (the most recent).

Hi, you could also use the first() function:

first(select MyTable.mydate)

That will give you the first entry of that table that has a content in the field mydate.

Best, Jörg

Since the most recent record would have the highest Id#, you can also do this:

max(number(select MyTable where Date < myDate).Id)

Ok, I'll try those. Thank you.

Ninox is very powerful, but a comprehensive reference would be most welcome.

Agreed!

Those solutions didn't work for me.

The last record may not have the most recent date. Uptown aces no deposit bonus 2017.

I'm trying to copy some field content from the record with the most recent date.

I have an ugly workaround with a loop :

let myDate := 'Date Field';

let targetDate := 0;

for q in select 'Table' where number('Date Field') < myDate do

The last record may not have the most recent date. Uptown aces no deposit bonus 2017.

I'm trying to copy some field content from the record with the most recent date.

I have an ugly workaround with a loop :

let myDate := 'Date Field';

let targetDate := 0;

for q in select 'Table' where number('Date Field') < myDate do

if number(q.'Date Field') > targetDate then

'Field to copy' := q.'Field to copy';

targetDate := number(q.'DateField');

end

end

There must be a more elegant solution !

Hi Ludo,

if you go with Lauras suggestion to max instead of first:

max(select MyTable.mydate)

you will get the most recent date.

Best Jörg

Hi Ludo

---

let lastDATE:=max(select 'Table'.'Date Field');

'Field to copy':=last(select 'Table' ['Date Field'= lastDATE]).'Field to copy';

---

Lyn 1 9 8 – lightweight image browser and viewer. Leo

Elegant, Jörg! Very helpful. Thanks for the tip.

In this wiki I'd like to clarify the confusion regarding the different versions of Crystal Reports and what version of Visual Studio .NET they work with.

As with most of my other wikis, I use a simple matrix that describes all the possible scenarios. Please note that the matrix only goes back to Crystal Reports version 9.1. Personally, I would not even try versions earlier than 9.1. Not to mention that earlier versions of Crystal Reports are not supported in any version of .NET. However if you have success, please do post your findings in our forums.

* Indicates version of assemblies for framework 2.0 and 3.5

For more information including latest download links for Merge Module files, see the 'Crystal Reports for Visual Studio .NET Runtime Distribution - Versions 9.1 to 12.0' wiki here:

Another useful wiki maybe 'What versions of Crystal Reports are supported on Windows Vista in VS .NET?' available at this link:

For more help, don't forget to search the SAP notes:

articles:

and downloads: