Solved

Month Function

Posted on 2008-06-20
2
1,049 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
ID: 21832662
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
ID: 21832756
Perfect
Thanks so much
Al
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

829 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