Input Box and Load Data

[jagjivvt]

Hi,

i need to load data that has a field Date and Time. i have created an input box where i insert the date and time and using where clause in the load script i have a variable. however when applying this it does not load any data.

example

ActivityDate     06/02/2017 15:01:30

My data has various dates in the file and only want to load the rows that are greater then the above date.

in the load script is have right "Where ActivityDate>'$vActive';

thanks

vijay    

[vishsaggi]

May be try this?

Where Date(Date#(ActivityDate, 'MM/DD/YYYY hh:mm:ss' ), 'MM/DD/YYYY hh:mm:ss') > '$(vActive)' ;

OR This?

Where Date(Date#(ActivityDate, 'MM/DD/YYYY hh:mm:ss' ), 'MM/DD/YYYY hh:mm:ss') > Date(Date#('$(vActive)' , 'MM/DD/YYYY hh:mm:ss'), 'MM/DD/YYYY hh:mm:ss')

[jagjivvt]

Hi

thanks tried both but no success

vijay    

[vishsaggi]

Can you share your app you are working on, when i used my test data it worked fine. It would be easy if i can look into your app to work on?

[jagjivvt]

Hi

please see attached qvw and the excel workbook

thanks

[vishsaggi · Accepted solution]

Try this by changing your excel path.

Keep changing your variable dates and reload.

[jagjivvt]

Thanks , this works perfect.