HI All

Hi rameshm,

Can you please clarify once if it datetime or date..

if it is datetime, in the column contains time..so we can fetch the data using query entity.

Hi BhanuPrakashm,

it is datetime filed

Thanks..

Hi BhanuPrakash,
please provide If you sample code it will helps....
Thanks

Are you simply looking for the value with which to compare? If so, the below may help, but bear in mind you'll need to take into consideration the relevant timezones.

datetime(
year(
today() - 7
),
month(
today() - 7
),
day(
today() - 7
),
10,
0,
0,
0
)

If the week and times are always known, I like to create a view with this criteria. Then I allow Appian to pull the data back that is needed and not have to worry about doing the filtering. Not sure if that works in your use case, but something to think about.