Solved

Month Function

Posted on 2008-06-20
2
1,046 Views
Last Modified: 2013-11-15
hi,
I am new to crystal reports.
When writing a report I came across the need to have a date on my report.
The report is a statement and needs to have an as of date.
I would like it to be the first of the month EXP. June 1,2008 or 06/01/08.
The date needs to change as the months change. it always needs to say the first of the month so I can not use the print date function.
How do I go about this?
Thank you for your help

Al
0
Comment
Question by:lacroix_al
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
Comment Utility
You can create a formula field to get the first of the current month:
All you need is:

Dateserial(Year(currentdate), Month(currentdate),1)
0
 

Author Comment

by:lacroix_al
Comment Utility
Perfect
Thanks so much
Al
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now