如何在水晶报告中转换日期时间？

问题描述

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)

推荐答案

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.

这篇关于如何在水晶报告中转换日期时间？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！