Hi I have a scenario wherein I am displaying data in a grid on SAIL f

komalc3

A Score Level 1

over 8 years ago

Hi

I have a scenario wherein I am displaying data in a grid on SAIL form via. a!queryEntity.
I have to provide two filters to user of Start date and End date (both calendars) which actually will query the same column in my DB whose type is timestamp i.e. between the range of this start and end date selected, the data will be filtered in the grid.

If I try to achieve this via. where(search(....)) on a!queryEntity I get an output where my date in DB is equal to the date selected in user filter.

So I guess I need to do it via. a!queryEntity as a number of operators are available here, but not able to figure it out how to do the same.

Can any one please guide me how to achieve this functionality.

Thanks in advance....

Discussion posts and replies are publicly visible

Parents

0 komalc3
A Score Level 1
over 8 years ago

Thank you sikhivahans, Nick for you replies!!

Nick, the Primary Timezone in my settings is: UTC-5:00

sikhivahans, I tried using userdatetime(), the date now I got as a result is the same as that I selected from the calendar but irrespective I use hour(),minute(),second(); I get the time as 12:00 AM EST i.e. if I selected date 12/23/2015 from the calendar, I get the result with userdatetime() as: 12/23/2015 12:00 AM EST.

Also if the date stored in DB is:
2015-08-20 00:00:00
and I simply display this column in my a!textfield() I get the result
8/19/2015 8:00 PM EDT.

Can you please guide me.

Thank you in advance!!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 komalc3
A Score Level 1
over 8 years ago

Thank you sikhivahans, Nick for you replies!!

Nick, the Primary Timezone in my settings is: UTC-5:00

sikhivahans, I tried using userdatetime(), the date now I got as a result is the same as that I selected from the calendar but irrespective I use hour(),minute(),second(); I get the time as 12:00 AM EST i.e. if I selected date 12/23/2015 from the calendar, I get the result with userdatetime() as: 12/23/2015 12:00 AM EST.

Also if the date stored in DB is:
2015-08-20 00:00:00
and I simply display this column in my a!textfield() I get the result
8/19/2015 8:00 PM EDT.

Can you please guide me.

Thank you in advance!!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data