Search on current date

Search on current date

  

Hi,

I need to implement search range of dates if  i give the range as a currdate() in both the input fields the search is not happening  because the default date in the input fields of calendar is currdate() and i don't want it to set it to nulldate().

this is my filter condition


From= CurrDate() or movie.Posting_Date >= From


movie.Posting_Date <= To

Thanks,

Ronan T.

Ronan T wrote:

Hi,

I need to implement search range of dates if  i give the range as a currdate() in both the input fields the search is not happening  because the default date in the input fields of calendar is currdate() and i don't want it to set it to nulldate().

this is my filter condition


From= CurrDate() or movie.Posting_Date >= From


movie.Posting_Date <= To

Thanks,

Ronan T.


Hello Ronan,

Can you share your oml, will be easier to understand your problem?


KR,

Ruben Bonito

Sorry, I'd like to help you, but your question is a bit confusing. Can you clarify what you really want, and what Debug is giving you back?

Ruben Bonito wrote:

Ronan T wrote:

Hi,

I need to implement search range of dates if  i give the range as a currdate() in both the input fields the search is not happening  because the default date in the input fields of calendar is currdate() and i don't want it to set it to nulldate().

this is my filter condition


From= CurrDate() or movie.Posting_Date >= From


movie.Posting_Date <= To

Thanks,

Ronan T.


Hello Ronan,

Can you share your oml, will be easier to understand your problem?


KR,

Ruben Bonito

Hi Ruben Bonito,

Sorry I cannot share the oml

Thanks,

Ronan T.


Nuno Miguel da C Fernandes Verdasca wrote:

Sorry, I'd like to help you, but your question is a bit confusing. Can you clarify what you really want, and what Debug is giving you back?

Hi Nuno Miguel da C Fernandes Verdasca,

I need to implement search on range of dates if the range is current date the search is not happening.

Thanks,

Ronan T.


And are you using Date or DateTime on survey dates?

Miguel Verdasca

Nuno Miguel da C Fernandes Verdasca wrote:

And are you using Date or DateTime on survey dates?

Miguel Verdasca

I am using date

Thanks,

Ronan T.


Ronan T wrote:

Ruben Bonito wrote:


Hello Ronan,

Can you share your oml, will be easier to understand your problem?


KR,

Ruben Bonito

Hi Ruben Bonito,

Sorry I cannot share the oml

Thanks,

Ronan T.


Hi Ronan,

You can always create a small module that reproduces the problem, when you can't share the module where you are working on.

In any case, the input must be associated with a variable. If no date is provided, it should be set to NullDate() (1900-01-01) and this value would be in the NullValue of the input.

So, which calendar widget are you using?

Cheers.

I do not know which component you're using, but have tried using this:

https://www.outsystems.com/forge/component/4196/date-time-picker-range/?Unfollow=False

Here we can set default search dates. I'm currently using it in my project, and it works fine.



Nuno Miguel Verdasca

Did you solve the problem?


Miguel Verdasca

Nuno Miguel Verdasca wrote:

Did you solve the problem?


Miguel Verdasca

Hi,

I have shared my oml,please suggest me if any changes has to be made.

https://ronan-t.outsystemscloud.com/Demo/Entry1.aspx?_ts=636785207613169892

Thanks,

Ronan T


Nuno Miguel Verdasca wrote:

Did you solve the problem?


Miguel Verdasca

Hi,

The issue has been solved.

Regards,

Ronan T


Hi Ronan,

Can you explain what caused the issue? That may be relevant for anyone in the future with the same problem, who finds this topic looking for a solution.

Ronan T wrote:

Nuno Miguel Verdasca wrote:

Did you solve the problem?


Miguel Verdasca

Hi,

The issue has been solved.

Regards,

Ronan T


I'm glad to hear that you've been able to solve the problem. I hope I've been able to help you find a solution to your problem.


Regards,

Nuno Miguel Verdasca