Neckermann
Programmer
Hello,
I am using Impromptu 7.4 to make raports. I want to make a report that only give me data of yesterday. Therefor i use the query
Intervalstart = add-days (datetime-to-date ( now ()), -1)
When i run the report i get the following error message:
Error number -239:
DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'.
EXPENG-E-TYP2, The operation <equal> is invalid for data types <character> and <datetime>.
Can anyone please help me?
I am using Impromptu 7.4 to make raports. I want to make a report that only give me data of yesterday. Therefor i use the query
Intervalstart = add-days (datetime-to-date ( now ()), -1)
When i run the report i get the following error message:
Error number -239:
DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'.
EXPENG-E-TYP2, The operation <equal> is invalid for data types <character> and <datetime>.
Can anyone please help me?