Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Formatting Date

Good Day All,

I have two parameter fields FromDate and ToDate in the system that are represented like 05/01/2008, 05/31/2008 respectively.

I want to concatenate these fields to read as follow; May 1 TO May 31, 2008.

I was able to format both date fields in format editor, to read as follow May 1 , May 31, 2008

but when I put both fields in a formula they convert back to there original state of 05/01/2008 12:00:00 am 05/31/2008 12:00:00 am.

My formual is {@FromDate} & " " & "To" & " " &{@ToDate} and I tried the Totext function and that doesn't give me the desired results.

Thanks

David M.

replied

Hi David,

Try this:

ToText ({?FromDate}, "MMM dd") & " To " & ToText ({?ToDate}, "MMM dd yyyy");

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question