Print Page | Close Window

Getting data from last year and 11 months

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22661
Printed Date: 27 Apr 2024 at 3:34am


Topic: Getting data from last year and 11 months
Posted By: barry.ein
Subject: Getting data from last year and 11 months
Date Posted: 21 Aug 2018 at 6:19am
Hi,

Let's say today is August 21st and I want to get values from September 1st 2017

Which formula can I use in order to do that?

Thanks,

Barry



Replies:
Posted By: DBlank
Date Posted: 21 Aug 2018 at 6:50am
table.datefield >= dateserial(year(today),month(today)-11,1)



Print Page | Close Window