Crystal 报表将 DateTime 转换为字符串 给此函数提供了太多参数

Crystal report converting DateTime to string Too many arguments have been given to this function(Crystal 报表将 DateTime 转换为字符串 给此函数提供了太多参数)

问题描述

我在水晶报表中有一个简单的公式，如下所示:

I have a simple formula like below in crystal report:

iif(isnull({employ.createdDate}),"", ToText({employ.createdDate}, "dd-MMM-yyyy"))

{employ.createdDate} 格式如下:

02/09/2015 10:48:25

{employ.createdDate} 为 null 时可以正常工作，但当它不为 null 时，会显示以下错误消息:

It works fine when {employ.createdDate} is null, but when it's not null, the below error message shows:

  Too many arguments have been given to this function 
  Error in File employeeInfo.rpt: 
  Error in formula txtDate

删除dd-MMM-yyyy"确实解决了问题，但我想将日期格式化为dd-MMM-yyyy"格式，即09-FEB-2015"

Removing the "dd-MMM-yyyy" does solve the problem but I would like to format the date to "dd-MMM-yyyy" format i.e. "09-FEB-2015"

公式有什么问题?

推荐答案

哦，我想通了...

02/09/2015 10:48:25 是字符串格式，所以我需要将其转换为日期并将其转换为字符串，我将公式修改为这个，它可以工作:

The 02/09/2015 10:48:25 is in string format, so I need to convert it to date and convert it to string, I modified the formula to this, and it works:

ToText(cDate({employ.createdDate}),"dd-MMM-yyyy")

这篇关于Crystal 报表将 DateTime 转换为字符串 给此函数提供了太多参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！