last 150 days

[Anonymous]

Hi,

I would like to restrict the number of rows returned to the last 150 days from today(). I can't seem to find any using posts on the forum on how this is done, would be grateful for some assistance.

I require this in the where clause of the load editor.

thanks in advance.

[olivierrobin · Accepted solution]

hello

I suppose you have a date in the data you load

so a where clause like

where CurrentDate-DateLoaded<=150 should work

you have to set CurrentDate to Today's date according to the date formats you treat

[Anil_Babu_Samineni]

Number of rows - You want to show in chart? If((DateField - Today())<150, DateField)

[Anonymous]

Thanks Olivier.

I had to slightly tweak the query to:

Ready - Today()  <=150

[olivierrobin]

remember to check the date format

if the answer is correct, remember to tag it correct and close the thread