Hi,
I have a requirement to calculate the last month.
Actual scenario:
User entera a date range and wants to see data that comes from before a month. where there are other attributes that fall would be calculated as per the given date range.
Report Scenario:
User is prompted to enter a date range ( creation from and creation to date and above that date range I am substituting a report variable as
report object:
days between
[syntax:: =DaysBetween( ,CurrentDate())]
close date object is a direct universe date object.
the above report object [days between] has to be calculated for last month.
So I had created a report object and had given a direct calculation
-30.
Since we have months with 28,30 and 31days. the above scenario won’t fetch effective result.
Could you kindly help how I could counter the above issue.
I had tried the below mentioned report object to solve this issue. but the syntax is wrong. could you kindly help me out.
Previous month
= If (MonthNumberOfYear(CurrentDate())=(“1”,“3”,“5”,“7”,“8”,“10”,“12”) )then days between - 31 else If MonthNumberOfYear(CurrentDate())=(“4”,“6”,“9”,“11”) )then days between - 30 else days between - 28
Thanks
Regards
Shible
shible (BOB member since 2006-12-26)