Date to endquarter function?

[#1]

Hi

I have to calculate the days from today()-1 to the end of the cuarter.

There is any function similar to InQuarterToDate?

Thank you

Greetings

[maxgro]

date between today()-1 and end quarter

tmp:

load

  date(makedate(2015) -1 + rowno()) as date

autogenerate 366;

Right keep (tmp)

load

  date

Resident tmp

where date > (today()-1) and InQuarter(date, today(), 0);

[#3]

Thank you, finally i did this to count the number of days

round(QuarterEnd(today()) - today () ) -1)

[Anonymous · Accepted solution]

This should work:

QuarterEnd(today()) - (today()-1)

[#5]

Yeah i've done that

Thank you for your help

Greetings