Print Page | Close Window

1st day of current month

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=13666
Printed Date: 04 May 2024 at 6:46pm


Topic: 1st day of current month
Posted By: VickiM
Subject: 1st day of current month
Date Posted: 05 Jul 2011 at 3:49am
Hi!  Does anyone know how to show:
 
< first day of current month
 
in crystal XI?
 
Thanks!
 
VMM


-------------
VickiM


Replies:
Posted By: DBlank
Date Posted: 05 Jul 2011 at 3:53am
one way...
date(year(currentdate),month(currentdate),1)

Posted By: VickiM
Date Posted: 05 Jul 2011 at 4:02am
Cool, thank you.  So how would you show first day of last month?

-------------
VickiM

Posted By: DBlank
Date Posted: 05 Jul 2011 at 4:22am
dateserial(year(currentdate),month(currentdate)-1,1)

Posted By: DBlank
Date Posted: 05 Jul 2011 at 4:23am
there is also the
lastfullmonth
 
so you can do things like
table.date in lastfullmonth
to get all your rows from last month

Posted By: VickiM
Date Posted: 05 Jul 2011 at 4:26am
Okay thank you very much!

-------------
VickiM


Print Page | Close Window