ids of bes unmanagedassets whose
(
exists
(
current date - it
)
whose
(
it < 7 * day
)
of
(
it as date
)
of
(
(
(
it as integer as string
)
of preceding text of last "/" of following text of first "/" of it
)
&" "&
(
preceding text of first "/" of it as integer as month as three letters
)
&" "&
(
following text of last "/" of it as integer as string
)
)
of
(
preceding text of first " " of it
)
of values of fields whose
(
"Import Time (Server Time)" = name of it
)
of it
)
ids of bes unmanagedassets whose(exists (current date - it) whose(it < 7 * day) of (it as date) of ( ((it as integer as string) of preceding text of last "/" of following text of first "/" of it ) &" "& (preceding text of first "/" of it as integer as month as three letters)&" "& (following text of last "/" of it as integer as string)) of (preceding text of first " " of it) of values of fields whose("Import Time (Server Time)" = name of it) of it)