Specifying current date and substring in virtual table

[Maximus_Jack]

Hi
i'm trying to create conditions for virtual table in column analysis,
having difficulty in specifying "current date" and extracting date from timestamp column and comparing, like below, can someone help me?

col1 <= sysdate /* how to specify sysdate in the condition box
date(col2) < '2013-12-31' /*how to extract date from timestamp and comparing against a specified date, the data type of col2 is timestamp

cheers
mj

[ray.wurlod]

This is only a guess: CurrentDate() from the functions list.

[Maximus_Jack]

thanks for your response..

tried that
col1 < Currentdate()

but not working, getting error as
"The where clause is invalid, please make sure the structure is correct, the column names are correct, and if necessary values are properly quoted.

[ray.wurlod]

Did you select the function from the list in the tabbed dialog on the right hand side? (Note, too, that CurrentDate() was only a guess - I don't have IA available right now.) I'm thinking that the function name may be case sensitive.

[rjdickson]

I do not think it is possible in the GUI. You will need to create an xml fragment and run it via the command line.

Since you have opened another question on that topic, I will answer you there.

Reference: viewtopic.php?t=150610