topic Re: How to get date 10 years older to the current date in App Development

How to get date 10 years older to the current date

Thu, 18 Feb 2016 12:18:55 GMT

Hello All,

Struggling with an issue which i thought would be rather simple.

I would need to do an bring up some data from SQL based on dates and the difference btwn them should be exactly 10 years.

Ex: If any user opens the app today they should be able to see date ranging from 2/18/2006 to 2/18/2016.

TIA!!

kaushiknsolanki — Thu, 18 Feb 2016 17:40:46 GMT

Hi,

Use Addyears function.

Addyears(Date,-10)

Regards,

Kaushik Solanki

sunny_talwar — Thu, 18 Feb 2016 18:27:58 GMT

May be set a variable like this:

MaxDate:

LOAD Date(AddYears(Max(Date), 10), 'DD-MMM-YYYY') as MaxDate,

Date(Max(Date), 'DD-MMM-YYYY') as MinDate

Resident YourFactTable;

LET vMaxDate = Peek('MaxDate);

LET vMinDate = Peel('MinDate');

DROP Table MaxDate;

SQL

SELECT *

FROM Table

Where DateField >= $(vMinDate) and DateField <= $(vMaxDate);