Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Pls find the attached calendar qvd, in this i have continuous dates in it, what i want is right now i am @ 27 May 16,
I want to calculate no of days of current month till Date.
As per todays days 27 May 16, No of Days should be 27
pls suggest ho i can handle the continuous dates ,, i m getting 31
Why do you need a calendar to do that. Have you tried this -> Day(Today())
Hi,
bcoz if i will select last month than it will not give me total no of days of that month.
any suggestion as per calendar dates?
try
Day(Date) as Days
or
floor(Date)-floor(monthstart(Date)) as Days
I guess try what Kush mentioned
Day(Date)
and on the front end just use Max(Day) based on your selection of Month it should change.
But i am not getting 27 days..getting 30 in may
May be try like this:
If(Today() >= Date, Day(Date), Day(Today()) as ModifiedDay
HI,
Check the attached
It may work
temp:
LOAD [Calendar Date],
link_Date,
Days,
Weeks,
WeekDays,
[Week Start],
[Week End],
[Calendar Year],
[Calendar Month],
[Fiscal Month Num],
[Calendar Month Num],
[Fiscal Quarter],
[Fiscal Year],
[FY Year Name],
[Month Start],
[Month End],
[Quarter Start],
[Quarter End],
[Fiscal YYYYMM],
[Calendar Month Year],
[Fiscal Month]
FROM
[..\Downloads\Stage2_Calendar.qvd]
(qvd);
twef:
LOAD count(if(MonthName([Calendar Date])=MonthName(Today()),[Calendar Date])) as countdays
Resident temp where [Calendar Date]<=Today();