Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: 1st day of current month Post Reply Post New Topic
Author Message
VickiM
Newbie
Newbie
Avatar

Joined: 02 May 2011
Location: United States
Online Status: Offline
Posts: 28
Quote VickiM Replybullet Topic: 1st day of current month
    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
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 05 Jul 2011 at 3:53am
one way...
date(year(currentdate),month(currentdate),1)
IP IP Logged
VickiM
Newbie
Newbie
Avatar

Joined: 02 May 2011
Location: United States
Online Status: Offline
Posts: 28
Quote VickiM Replybullet Posted: 05 Jul 2011 at 4:02am
Cool, thank you.  So how would you show first day of last month?
VickiM
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 05 Jul 2011 at 4:22am
dateserial(year(currentdate),month(currentdate)-1,1)
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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


Edited by DBlank - 05 Jul 2011 at 4:24am
IP IP Logged
VickiM
Newbie
Newbie
Avatar

Joined: 02 May 2011
Location: United States
Online Status: Offline
Posts: 28
Quote VickiM Replybullet Posted: 05 Jul 2011 at 4:26am
Okay thank you very much!
VickiM
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.032 seconds.