Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Month Function

Posted on 2008-06-20
2
Medium Priority
?
1,060 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 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
How to increase the row limit in Jasper Server.
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Loops Section Overview
Suggested Courses

885 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