enquiry for additional filter to have

[WeiMingLeong]

HI all Thank you for reading my post.

i am wondering whether can i add addition filter to claim amount value to have from 1 Jan 2022 to 31 Dec 2022 into my current filter for sum.

My Lineitems list have InvoiceDate column and i would like to use invoicedate to sum from 1Jan 2022 to 31Dec 2022 for the selected category value.

There will be no selection of date as i would like to straight alway enforce it to be 1 year each time.
As it already have this formula in it.

Sum(
Filter(
    LineItems,
LookUp(Expenses,ReportID.Id=ID).Status.Value="Completed",Category.Value="Staff Welfare - Medical / Dental",RequestorLI.Email=User().Email),TotalAMOUNTSGD)

[NandiniBhagya20 · Accepted solution]

Sum(
Filter(
    LineItems,
LookUp(Expenses,ReportID.Id=ID).Status.Value="Completed",Category.Value="Staff Welfare - Medical / Dental",RequestorLI.Email=User().Email, Created >= DateTimeValue("1 January 2022"), Created <= DateTimeValue("31 December 2022")),TotalAMOUNTSGD)

[WeiMingLeong]

@NandiniBhagya20 thank you for your help.
your solution work!