
Anonymous
Not applicable
2018-01-30
10:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to select the last date before an other date
Hello,
I'm having difficulty trying to get the last date of an activity compared to a date in a other table.
I have the following tables:
System
System | Test | Timestamp |
---|---|---|
Test_system_A | Test_cycle_1 | 2018-01-01 12:08:09 |
Test_system_A | Test_cycle_4 | 2018-01-03 11:08:49 |
Test_system_B | Test_cycle_3 | 2018-01-02 16:16:09 |
Test_system_A | Test_cycle_2 | 2018-01-05 08:08:19 |
Test_system_A | Test_cycle_9 | 2018-01-06 20:18:09 |
Config
System | Configuration | Timestamp |
---|---|---|
Test_system_A | config1a | 2018-01-01 08:08:09 |
Test_system_A | config1b | 2018-01-05 20:08:09 |
Test_system_B | config1a | 2018-01-01 10:08:09 |
The report should show the number of test cycles have been performed on which system and configuration and when the last test cycle has been performed.
The outcome should look like this:
System | Configuration | Nbr of test cycles | Last test cycle performed |
---|---|---|---|
Test_system_A | config1a | 3 | 2018-01-05 08:08:19 |
Test_system_A | config1b | 1 | 2018-01-06 20:18:09 |
Test_system_B | config1a | 1 | 2018-01-02 16:16:09 |
Is there a sollution for this situation?
487 Views
0 Replies
