This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

<@U2A2VHL3W> your tip resulted into this code
        var currencyrateSearch = nlapiSearchRecord("currencyrate", null,
        [
            ["basecurrency", "anyof", "1"],
            "AND",
            ["transactioncurrency", "anyof", "2"],
            "AND",
            ["effectivedate", "on", toDate]
        ],
        [
            new nlobjSearchColumn("exchangerate", null, null)
        ]
    );