Append Dates-Excel output

idontknow · 2009-12-19

in a report which has excel output,in one field i need to print like this : "Sep 26th to Oct 2nd"

I can get both the dates but want to know how to append both the dates in a single line?

navfresher · 2009-12-21

idontknow wrote:

in a report which has excel output,in one field i need to print like this : "Sep 26th to Oct 2nd"

I can get both the dates but want to know how to append both the dates in a single line?

Any solution please?

Savatage · 2009-12-21

have you looked at the FORMAT property?

StartDateTxt := FORMAT(Date1,0,'<Month Text,3> <Day>.');
EndDateTxt := FORMAT(Date2,0,'<Month Text,3> <Day>.');
DateRangeTxt := StartDateTxt+' to '+EndDateTxt;

You can probably do it all in one line of code
DateRangeTxt := (FORMAT(Date1,0,'<Month Text,3> <Day>.'))+' to '+(FORMAT(Date2,0,'<Month Text,3> <Day>.'))

then export that variable to excel.
Is this what you're looking for?

Saalek · 2009-12-21

Hi

If you record a macro in Excel, the function is that

Selection.NumberFormat = "[$-C0A]d-mmm;@"

Bye

Append Dates-Excel output

Comments

Categories