Solved

Month Function

Posted on 2008-06-20
2
1,048 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

810 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