How to convert date time in crystal report?

Question

1.00/5 (1 vote)

See more:

I am trying to convert date time in Crystal report. My date is 12 2017 and i want to convert it into december 2017 but it gives me error

<pre>MonthName (val(left({Table1.MonthYear},2))) + ' - ' + right({Table1.MonthYear},4)

a string is required.

Note: it works on current month year but gives error in previous month.

What I have tried:

<pre>MonthName (val(left({Table1.MonthYear},2))) + ' - ' + right({Table1.MonthYear},4)

Posted 29-Jan-18 20:25pm

Member 13651104

Updated 29-Jan-18 20:38pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

debasish mishra · Answer 1 · 2018-01-29T20:37:00

Solution 1

ToText(CDate({Table1.MonthYear}),"MMM yyyy");

or

local datevar a :=CDate(Left({Table1.MonthYear},2) +' - ' +  Right({Table1.MonthYear},4));
 local numbervar y := Year (a); local numbervar d := Month (a); Date (d, y);

Try above and let me know.

Posted 29-Jan-18 20:37pm

debasish mishra

Updated 29-Jan-18 21:08pm

v3

Comments

Member 13651104 30-Jan-18 2:50am

It gives error
MonthName ToText(CDate({Table1.MonthYear}),"MMM yyyy")

the remaining text doesnot appear to be the part of formula

[no name] 30-Jan-18 2:57am

Any syntax mistake like semi colon or anything?

Member 13651104 30-Jan-18 2:59am

ok i will check

[no name] 30-Jan-18 3:01am

BTW CDate is a function

Member 13651104 30-Jan-18 3:16am

cdate is inbuilt function?

[no name] 30-Jan-18 3:19am

Yes

Member 13651104 30-Jan-18 3:29am

now it gives bad date formating and in 2nd one it give error Date (d, y); not enough argument.

Member 13651104 30-Jan-18 3:50am

MonthName (val(left({Table1.MonthYear},2))) + ' - ' + right({Table1.MonthYear},4)

this works on current monthyear but gives error in previous monthyear

[no name] 30-Jan-18 4:41am

Do you get values in variable a??Leave the Y and d variable and write only local datevar a :=CDate(Left({Table1.MonthYear},2) +' - ' + Right({Table1.MonthYear},4)); and check its value