Skip to main content
Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

last 150 days

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.

1 Solution

Accepted Solutions
olivierrobin
Specialist III
Specialist III

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

View solution in original post

4 Replies
olivierrobin
Specialist III
Specialist III

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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

Thanks Olivier.

I had to slightly tweak the query to:

Ready - Today()  <=150

olivierrobin
Specialist III
Specialist III

remember to check the date format

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