Need to trim off the 0 in 09/17/07

[wrighterb]

Need to trim off the 0 in 09/17/07 but only if it is a zero

Any Ideas, it will be happening in a loop.

Thanks.

 

[LyndonOHRC]

trim off the 0 in 09/17/07 " there are two zeros in your example.

To remove leading zero only:

<cfset mdate='09/17/07'>
<cfif left(mdate,1) eq '0'>
	<cfset mdate=mid(mdate,2,len(mdate)-1)>
</cfif>

To remove all zeros:

<cfset mdate='09/17/07'>
<cfif find('0',mdate)>
	<cfset mdate=replace(mdate,'0','','ALL')>
</cfif>

Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel. Covey

 

[cfStarlight]

If its a date/time value you could use dateFormat to skip the leading zero.

#DateFormat(dateValue, "m/dd/yy")#

 

[wrighterb]

Thank you very much!