When asked to return dates, FieldQuery() sometimes returns very large integers (billions) instead of either a date string or the usual floating point internal date format. Here are some examples tested in Zelda (running directly in MC gives same results):
Expressions/returns which work ok:
[Name]
_25 Trips (back cover).jpg
[album]
25 Trips
[Media Type]
Image
[Type:Folder]
Image:D:\Music - Mark\Sierra Hull\25 Trips\
fieldquery(Type:Folder, Image:[Filename (path)], Name, 1, 0)
_25 Trips (digipack 02).jpg;_25 Trips (back cover).jpg;_25 Trips (digipack 03).jpg;_25 Trips (front cover).jpg
fieldquery(Type:Folder, Audio:[Filename (path)], Name, 1, 0)
Beautifully Out Of Place;Middle Of The Woods;How Long;25 Trips;Ceiling To The Floor;The Last Minute;Escape;Poison;Waiting;Everybody's Talking;Envy;Less;Father Time
[Last Played]
6/9/2021 3:54 pm
ConvertDate([Last Played])
44356.6624999999985448
Expressions/returns for Last Played date which do not work ok?:
Returns a list as expected, but very large integers (billions value). Bug??:
fieldquery(Type:Folder, Audio:[Filename (path)], Last Played, 1, 0)
1623269013;1622935860;1619670197;1619670443;1619670672;1619670859;1619671055;1619671263;1619671529;1619671674;1619671822;1619672074
ListMath() to find largest of these very large integers returns the first value in the list, which is ok.
ListMath(fieldquery(Type:Folder, Audio:[Filename (path)], Last Played, 1, 0), 1)
1623269013