where clause

[hwal]

Hi,

I want to setup a where clause (Asset Center connector) to process only records of the current date. For doing this I defined the following statements in the source connector where part:

LeftPart([dtLastModif]," ",0)= Date()

When I have a look at the output of these 2 statements (LeftPart & Date) they have the same value.

But I receive the following error:
'Asset Management' API error:'
Parsing error: invalid keyword near line 1 (text: '[')
Parsing error: invalid keyword near line 1 (text: ']')
Parsing error: invalid keyword near line 1 (text: '\"')
Parsing error: invalid keyword near line 1 (text: '\"')
line 1: syntax error 'LeftPart'; 'LeftPart' should be Select_field
line 1: syntax error '='; '=' should be Eof
Format error:'

Who has an idea what the problem could be?

thanks for an answer
Hanspeter

[thephantomlord]

LeftPart is strictly for string values. What you should try is:

datevalue([dtLastModif]) = date()