It looks like you're new here. Sign in or register to get started.
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?
Selection.NumberFormat = "[$-C0A]d-mmm;@"
Comments
Any solution please?
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?
http://www.BiloBeauty.com
http://www.autismspeaks.org
If you record a macro in Excel, the function is that
Bye