Incremental Reload DOUBT

[#1]

It is possible make the date comparission on the incremental reload in hour level, because when we put the date with DD/MM/YYYY HH:MM:SS the error script message appear, what can we do about it????

Any help will be appreciate

Regards,

Carlos

[disqr_rm · Accepted solution]

You may want to look into TIMESTAMP() or TIMESTAMP#() functions and store your date_time fields as numeric value. Then you can compare this numeric value and do incremental loads. Hope this helps.

[#3]

Thank You for your answer Rakesh, can i ask you a question?, how can i put a field in a listbox with some restrictions?? For example:

I have this table:

Emp Cta Desc

1 10 Carlos

2 20 Juan

and more rows like this

........

I want to put in the listbox only those who have Cta = 10

[disqr_rm]

Right click on th sheet -> New Sheet Object -> List Box

Drop down the Field --> Select <Expression>

Type Expression: if(Cta=10, Desc)

OK

Should work fine.

[#5]

Thank you again Rakesh, it works fine.

Greetings