Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Finding max(date) for a given date
Message
From
16/02/2016 18:43:16
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Finding max(date) for a given date
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows Server 2008 R2
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01631577
Message ID:
01631577
Views:
66
Helo comunity

I will need to find the last movement (higher) for a given date ordering by numeric code ascending to find the price field.
Suppose that i will have 3 movement with the same date, ex. 31.07.2015 where the first numeric code is 9, the secund is 10 and finally
the last is 25.
I need to write

Select max(datalc) from mytable where max(datalc) ="31.07.2015" order by numeric code desc

How to compare max(datalc) with the given date?
Max(datalc)=ctod('31.07.2015'), is this correct?

Thanks for your Help.
Best regards,
Luis
Next
Reply
Map
View

Click here to load this message in the networking platform