Retrieved data from latest date. (1 Viewer)

[NurulScare]

Hi all, Good Morning!!

I need your advise guys.
I have 2 tables
1. Quantity In by date
2. Quantity out by date.
Result: Quantity balance by date.
The problem is: I want to check my Quantity balance by latest date. Example below:

Scenario: From this stock balance, I want to create another query to plan production Quantity. Formula (Quantity Balance - New Order Quantity)
So how to retrieve latest date (19/1/2021 as example above)?
Can someone please help meeee. Thanks!

 

[June7]

See if this helps http://allenbrowne.com/AppInventory.html

 

[cb1]

could you not use the max function?

 

[NurulScare]

could you not use the max function?

can you explain details. sorry I am Newbie.

 

[cb1]

If I read your question properly it is as simple as below to get the latest date in a date/time.

select max([yourTable.dateField]) as LatestDate
from yourTable

 

[NurulScare]

If I read your question properly it is as simple as below to get the latest date in a date/time.

select max([yourTable.dateField]) as LatestDate
from yourTable

Still all date appear even when I put it on criteria.