Condition Statement

[jonick1205]

Anyone can help me to create a condition statement for the dates for example 01-01-21 to 01-31-21 my given date is 01/15/21 i only need to show  the less than 10 days and more that 10 days from 01/15/21.

[AngelosPachis]

Hey @jonick1205 ,

You can try the following expression :

Date>=DateTimeAdd(
                     Datetimeparse([Your_given_date_here],"%m/%d/%y")
                    ,10,"days")

OR 

Date<=DateTimeAdd(
                     Datetimeparse([Your_given_date_here],"%m/%d/%y")
                    ,-10,"days")

[Jonny]

Hi @jonick1205,

one idea for the IF statement would be:

ABS(DateTimeDiff([DateTime_Out],'2021-01-15','days'))

I've built an app from what I think I understand from your use case, hope it helps!

cheers!

[jonick1205]

hello thank you for the enter given date how can i enter my prefer date?

[Jonny]

Run as an analytical app