Get Closest Historical Value - system.tag.queryTagHistory

Ignition
1

I'm trying to use the system.tag.queryTagHistory to get the previous day's value that is closest to 1:00.
Based on the history for this tag, I would expect to get a value of 22,927.033, however, there is nothing being returned.

What am I missing here? Is there a better way of doing this?

Here are my parameters:

startDate= '04-12-2023 13:00:00'
endDate= '04-12-2023 14:00:00'
returnSize=-1
aggregationMode='LastValue'
noInterpolation=True

histTable = system.tag.queryTagHistory(paths=['[CoTags]OIL_HANDLING/COCHINA_OHF/STORAGE/STORAGE_TANK_COMMON/OIL_TANKS_TOTAL/ANALOG_VALUE'], startDate= '04-12-2023 13:00:00',endDate= '04-12-2023 14:00:00', returnSize=-1, aggregationMode='LastValue',noInterpolation=True)

image

2

I got this working, I used the wrong start and end date formats.

It should look like the following:

2023-04-12 13:00:00