topic Re: Current Date minus2 question in Application Development and Automation Discussions

Current Date minus2 question

Former Member — Thu, 30 Apr 2020 05:47:22 GMT

I am trying to create a dimension in IDT 4.2 that would show me the current date minus 2

I tried using this RelativeDate(CurrentDate();-2) ,however when i use this dimension in a filter when i run the query in webi it doesn't work.

Someone had sent me a code that pulls the first day of the month which works toDate(left(toString(curDate()),8)+'01')

Can i modify this one to pull current day minus 2? What would that syntax be?

Re: Current Date minus2 question

venkateswaran_k — Thu, 30 Apr 2020 06:32:44 GMT

Try as below

1. Where(Date = Relativedate(currentdate();-2))

1. Create a variable lv_day  = If([yourdate] <= RelativeDate(Currentdate();-2);1;0)
2. Filter your report by [lv_day] = 1

Regards,

Venkat

Re: Current Date minus2 question

venkateswaran_k — Thu, 30 Apr 2020 18:03:38 GMT

Is your problem resolved?

Re: Current Date minus2 question

venkateswaran_k — Sat, 02 May 2020 12:43:25 GMT

Dear Ian

Kindly update if your problem is resolved and update with the solution and mark the answer you accepted.

This will help others to get solution if they get similar issue.

Regards,

Venkat

Re: Current Date minus2 question

Former Member — Sun, 03 May 2020 06:43:58 GMT

When I use option 1, i still get an error.

Re: Current Date minus2 question

Former Member — Sun, 03 May 2020 06:43:59 GMT

When I enter it here..I still get an error message

Re: Current Date minus2 question

venkateswaran_k — Sun, 03 May 2020 06:47:58 GMT

You should put this condition in Where Box - not in select Box,

Re: Current Date minus2 question

Former Member — Sun, 03 May 2020 06:55:51 GMT

I tried adding this on IDT and didnt work.