Need to show less than 1 day tickets

[chinnu123]

Hi Team,

I am facing a issue on showing less than 1day tickets(<1day) .

I am using Today() and submit date i.e I need to show the tickets which was opened by only Today.

I used the below expression ..

If(Today()-Submit_Date< 1,Dual('<1 Day', 1)

Here I am getting issue like I am getting tickets which was raised by today and as well as Yesterday But I need to show only the tickets which was raised by today.

Can any one please assist me in this?

Thanks,

Chinnu.

[trdandamudi]

It should be as below:

If(Today()-Submit_Date=1,Dual('<1 Day', 1))

[vishsaggi]

What is your dateformat for Submit_Date here ? I mean is that 'MM/DD/YYYY' ?

[vishsaggi]

Or use = 0. IF (Today() - Submit_Date = 0, Dual('<1Day', 1)

[chinnu123]

Hi Vishu,

My date format is m/dd/yyyy.

I used above condition but its not working..

[chinnu123]

Hi Thirimala,

I used that condition but its not working as expected

Thanks,

Chinnu.

[vishsaggi]

Can you share a sample data or app to look into.? It works fine with some dummy data i created at my end.

[effinty2112 · Accepted solution]

Hi Chinnu,

                    Try:

If(Floor(Today()) = Floor(Submit_Date),Dual('<1 Day', 1))

Cheers

Andrew

[chinnu123]

Hi Andrew,

Thanks it working Correctly,

Thanks for your time

Thanks,

Chinnu.

[effinty2112]

Hi Chinnu,

          You're very welcome!

Kind regards

Andrew