Solved

Crystal Reports 6.0 date format in formula

Posted on 2002-03-13
3
185 Views
Last Modified: 2011-09-20
Hi,

I'm currenlty printing out the date in the formula listed below:

 ' beginning on '
+ ToText({CLASS_SCHEDULE.SCHD_DATE})

On most users machine the result is:

beginning on 12/18/2001

The problem comes in on a users machine where the the result shows:

beginning on 01/12/18


Any ideas as to why this is happening??


Thanks in advance!!!!!








0
Comment
Question by:TEALTEAL
  • 2
3 Comments
 
LVL 7

Expert Comment

by:EYoung
ID: 6861343
You need to close out you very overdue questions.  34 asked, only 18 closed.  Some going back months.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 50 total points
ID: 6862695
Check his default windows date format.  
  START -> SETTINGS  ->  CONTROL PANEL  ->  REGIONAL SETTINGS  ->  DATE tab

It is probably set as yy/mm/dd.

You can either fix it on his machine or better yet fix the report by formatting the field with the date in it.

good luck
mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 6882426
I believe you can use the format command in the formula.

mlmcc
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Crystal Reports 8.5 hangs 11 84
Crystal Report Grouping 8 55
Need to learn crystal reports 7 40
Crystal Reports Date Calculation 9 0
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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
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.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

705 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

14 Experts available now in Live!

Get 1:1 Help Now