You’re offline. This is a read only version of the page.
41
Hi I'm getting a SQL row of exchange rate date and filtering by certain rates and where the createdOn is today.
I can get it to work aside from the today filter. This is my filter expression:
TransactionCurrencyIdName eq 'US Dollar' or TransactionCurrencyIdName eq 'Australian Dollar' or TransactionCurrencyIdName eq 'Euro' or TransactionCurrencyIdName eq 'South African Rand' and CreatedOn eq @{formatDateTime(utcNow(),'yyyy/MM/ddT00:00:00Z')}
This is the error
An identifier was expected at position 202.
inner exception: An identifier was expected at position 202.
I can only assume tis is related to the data format/now expression can anyone please advise?
The CreatedOn data is in ISO 8601 -
"CreatedOn":"2016-10-25T07:46:03Z"
The filters work aside from the dates. The date in the data is
"CreatedOn": "2024-05-09T06:00:08Z"
I've tried filters using both the below that returns nothing using a static date and expression:
CreatedOn eq '2024-05-09T06:00:08Z'
utcnow('yyyy-MM-dd')
Share
Report
All responses (
Answers (
TransactionCurrencyIdName eq 'US Dollar' and CreatedOn eq '@{formatDateTime(utcNow(),'yyyy-MM-dd')}'
or TransactionCurrencyIdName eq 'Australian Dollar' and CreatedOn eq '@{formatDateTime(utcNow(),'yyyy-MM-dd')}'
or TransactionCurrencyIdName eq 'Euro' and CreatedOn eq '@{formatDateTime(utcNow(),'yyyy-MM-dd')}'
or TransactionCurrencyIdName eq 'South African Rand' and CreatedOn eq '@{formatDateTime(utcNow(),'yyyy-MM-dd')}'
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
