DateFormat Problem

Hi,

I've gone through various posts related to this topic but did not find the solution.

I have a smalldatetime field in SQLServer and I want to retrieve the value in "dd/mm/yyyy" format.

Below is the code for my formula field:

[Code Start]

IF {ListOfProjectsDeveloperWise.Fld_Invoice_Status} = "No" then

"Not Raised"

else

Left ({ListOfProjectsDeveloperWise.Fld_Invoice_name}, 3) & "-" & Date({ListOfProjectsDeveloperWise.Fld_Invoice_Date})

[Code End]

Fld_Invoice_Date is smalldatetime and i want to retrieve it in dd/mm/yyyy format. It is stored in mm/dd/yyyy format. I have tried various methods like datepart() etc but none yields suitable result.

Regards,

VinayHi

plz try this format

Date (YYYY, MM, DD)
Returns a Date value given numeric arguments of the year, month, and day.

Example :

The following examples are applicable to Crystal syntax:

Date ("Dec 31, 2005")
Returns the Date value for Dec. 31, 2005.

Date (#Oct. 20, 2005 12:02pm#)
Returns the Date value for October 20, 2005.

Date (2005, 7, 30)
Returns the Date value for July 30, 2005.|||No, it doesn't solve the problem.

regards,

Vinay|||Right click on the field and select format field Now you can choose the format you want