Subtract 30 days from promted date

[Former Member]

Hi experts,

I try to make a universe filter which give me 30 days before day prompted. On where condition I write something like this:

to_char(start_time) between (to_date(@prompt('Day','D',,,)) - interval '30' day) and to_date(@prompt('Day','D',,,)))

I have less days tan I expect. Do you know what is wrong on the sentence? do you have other way to do it?

Thank you

[sateesh_kumar1 · Accepted solution]

Hi Oscar ,

Syntax  is depends on database.

Ex : Island marketing universe.

@Select(Sales\Invoice Date)between @Prompt('Enter Date','D',,,,)-30 and @Prompt('Enter Date','D',,,,)

[Former Member · Accepted solution]

Yes Sateesh it was something like you describe, more or less what I was saying.

The problem was on the start_time format, as I defined as to_char, the days that I got were not the ones was expecting considering between filter,
.

Thanks