Format date with text

[mart10]

I am using CR10

I have a formula:

If {@NETINVESTMENT}>0 then "4. Please pay net settlement amount using the settlement instructions above for value: " &{@DealValueDate} else..........

Its fine except the date part comes out as dd/mm/yyyy and I want to see dd-mmm-yyyy

I cant format the date directly as it is a formula:
{@DealValueDate} = {DealMain.MaturityDate}+date(1961,12,31)

 

[jmd0252]

google Ken Hamady, He is the man with date formating, for Crystal Reports.

 

[mart10]

he isnt a free service, breaking house rule here!

 

[fisheromacse]

you can change the default display format for dates under File Menu- Options- Fields- Date Tab-

 

[lbass]

totext({DealMain.MaturityDate}+date(1961,12,31),"dd-MMM-yyyy")

-LB

 

[mart10]

Thanks IBASS