How can I query a date range for .msg emails using Azure AI Search?

Question

How can I query email created date for a range of dates in my Azure AI Search queries? I can't seem to find samples for either of the query JSONs below:

{ "queryType": "full", "search": "metadata_creation_date:???", "searchMode": "all" }

{ "search": "{{search}}", "select": "metadata_creation_date", "searchFields": "metadata_subject", "count": true }

Answer 1

This is how you can query JSON to retrieve .msg emails within a specified date range.

{
    "search": "*",
    "filter": "DateSent ge 'start_date' and DateSent le 'end_date'",
    "select": "From, To, CC, BCC, DateSent, Subject, Body"
}

{

"search": "*",

"filter": "DateSent ge '2023-01-01T08:00:00Z' and DateSent le '2023-01-02T08:00:00Z'",

"select": "From, To, CC, BCC, DateSent, Subject, Body"

}

I added indexing like this.

{
    "name": "email-index",
    "fields": [
        {"name": "MessageId", "type": "Edm.String", "key": true, "searchable": false},
        {"name": "From", "type": "Edm.String", "searchable": true, "filterable": true, "sortable": true, "facetable": true},
        {"name": "To", "type": "Collection(Edm.String)", "searchable": true, "filterable": true, "facetable": true},
        {"name": "CC", "type": "Collection(Edm.String)", "searchable": true, "filterable": true, "facetable": true},
        {"name": "BCC", "type": "Collection(Edm.String)", "searchable": true, "filterable": true, "facetable": true},
        {"name": "DateSent", "type": "Edm.String", "searchable": true, "filterable": true, "sortable": false, "facetable": true},
        {"name": "Subject", "type": "Edm.String", "searchable": true, "filterable": true, "sortable": true, "facetable": true},
        {"name": "Body", "type": "Edm.String", "searchable": true, "filterable": true, "sortable": true, "facetable": true}
    ]
}

I sent a sample data using this Doc.

{
        "MessageId": "1",
        "From": "[email protected]",
        "To": ["[email protected]", "[email protected]"],
        "CC": ["[email protected]", "[email protected]"],
        "BCC": ["[email protected]", "[email protected]"],
        "DateSent": "2023-01-01T08:00:00Z",
        "Subject": "Sample email 1",
        "Body": "This is the body of sample email 1."
    },
    {
        "MessageId": "2",
        "From": "[email protected]",
        "To": ["[email protected]"],
        "CC": ["[email protected]"],
        "BCC": [],
        "DateSent": "2023-01-02T08:00:00Z",
        "Subject": "Sample email 2",
        "Body": "This is the body of sample email 2."
    },
    {
        "MessageId": "3",
        "From": "[email protected]",
        "To": ["[email protected]"],
        "CC": [],
        "BCC": [],
        "DateSent": "2023-01-03T08:00:00Z",
        "Subject": "Sample email 3",
        "Body": "This is the body of sample email 3."
    }