=DateAdd("d", -1, Today())
Microsoft AX 2012, X++, C#, SQL server, SSRS, Java, JavaFX, Oracle, PL/SQL, Delphi - codes examples, step-by-step tutorials, experiences.
Showing posts with label ssrs - dateadd(). Show all posts
Showing posts with label ssrs - dateadd(). Show all posts
Friday, October 31, 2025
Friday, June 21, 2024
SSRS - How to get first and last day in month
These are useful functions, for example for parameter filling:
First and last day of this month:
First and last day of this month:
=dateadd("m",0,dateserial(year(Today),month(Today),1))
=dateadd("m",1,dateserial(year(Today),month(Today),0))
First and last day of last month:
=dateadd("m",-1,dateserial(year(Today),month(Today),1))
=dateadd("m",0,dateserial(year(Today),month(Today),0))
First and last day of next month:
=dateadd("m",1,dateserial(year(Today),month(Today),1))
=dateadd("m",2,dateserial(year(Today),month(Today),0))
Subscribe to:
Posts (Atom)
