0 votes

Hello,

I'm trying to get date parameters of query param window. and when i try to alert these parameters i got them in numbers. like the snapshots. any suggestions please?

enter image description here

enter image description here

enter image description here

asked in Efficy/ Client side by (559 points)

1 Answer

0 votes
Best answer

Hi Ammar,

it seems that some quote are mising in your function call. Without the quote, the parametre 01/02/16 will be the result of the division.(0.03125)

Alex.

answered by (775 points)
selected by
Hi Alexis,

You are correct, Thank you. And just to complete this answer. if this parameter is needed in query (mine was for ORACLE), then you can manipulate it to compare it to a DATE field like D_BEGIN:
D_BEGIN >= TRUNC(TO_DATE('the parameter', 'DD/MM/YY'), 'DDD')
Best Regards
1,167 questions
1,425 answers
1,717 comments
325 users