Hi
--{Warning: Complete DB and ACCESS N00B}--
I have a set of data that I update daily.
The data comes from a CSV. It contains a key, and 2 timestamps.
It looks something like this:
I have in my table of data added a coulmn called "First seen" it adds a date to all new records using now()
So my table looks like this:
And it works very well.
But I would like to add a column, lets call it, "LastSeen", that is the timestamp of the last import where that "Key" was present in an import. So when a "Key" is in an import, it should update the "LastSeen" time stamp. If it's not in the import it should leave the timestamp alone.
Kind regards JGaard
--{Warning: Complete DB and ACCESS N00B}--
I have a set of data that I update daily.
The data comes from a CSV. It contains a key, and 2 timestamps.
It looks something like this:
Key | LastScan | LastAgentTime |
Key1 | 08-03-2022 05:00:27 | 02-03-2022 02:14:13 |
Key2 | 08-03-2022 04:44:48 | 15-02-2022 02:48:01 |
Key3 | 07-03-2022 16:00:49 | 25-02-2022 11:08:31 |
I have in my table of data added a coulmn called "First seen" it adds a date to all new records using now()
So my table looks like this:
Key | LastScan | LastAgentTime | FirstSeen |
Key1 | 08-03-2022 05:00:27 | 02-03-2022 02:14:13 | 08-03-2022 09:17:28 |
Key2 | 08-03-2022 04:44:48 | 15-02-2022 02:48:01 | 09-03-2022 09:19:42 |
Key3 | 07-03-2022 16:00:49 | 25-02-2022 11:08:31 | 09-03-2022 09:19:42 |
And it works very well.
But I would like to add a column, lets call it, "LastSeen", that is the timestamp of the last import where that "Key" was present in an import. So when a "Key" is in an import, it should update the "LastSeen" time stamp. If it's not in the import it should leave the timestamp alone.
Kind regards JGaard