How to give date-range

[Deepa_7476]

Hi..
Glad to see a community for pipe-enthusiasts

I want to get the results for only the past 15 days
I cannot give FROM_DATE ( 1-may-07) TO_DATE ( 15-may07)..insted i want
something like FROM_DATE ( 15 days before now(date)) and TO_DATE( as
now(date))

How can i acomplish this?
any help is great help
thank you
Deepa

[Harish TM]

Hi Deepa,

                  Have you tried the Date Builder Module ( http://pipes.yahoo.com/pipes/docs?doc=modules#m3 )?  I think you will be able to do this by use of something like this:

FROM_DATE ( DateBuilder( 2 weeks ago) ) and TO_DATE( DateBuilder( Today ) )



Here is a description of the data builder module:

Date Builder

The Date Builder Module can create a date object from a string value. It understands most common date formats as well as relative date formats such as yesterday and 2 days ago.




Harish

[Deepa_7476]

Hi Harish
Thanks for the replay..Tired as many combinations i could think
of..perhaps i am missing the obvious.. could you please try it in
pipes and let me know if it works

Deepa