Crystal Reports 6.0 date format in formula

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!!!!!








TEALTEALAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
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
 
EYoungCommented:
You need to close out you very overdue questions.  34 asked, only 18 closed.  Some going back months.
0
 
mlmccCommented:
I believe you can use the format command in the formula.

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.