Breaking apart text

[izachar]

I have multiple drop downs so the user can select a month day and year to post a press release. I have to do this now in french. I created a dropdown with all the months in french and I am using the day and year from the original code. The problem is that when the user want to edit the field I need to break it down but now my existing code will not work because it is not a day/time field. Is there a way to break down a text field. If need be I will store delimiters like a comma to know where to separate?

 

[JHoarty]

If you can store your values using a delimiter like a ";", then you could use GetToken to extract the parts of your string.

<cfset datetimestring = &quot;jan;12;2001&quot;>

<cfset monthpart = GetToken(datetimestring, 1, &quot;;&quot>
<cfset daypart = GetToken(datetimestring, 2, &quot;;&quot>
<cfset yearpart = GetToken(datetimestring, 3, &quot;;&quot>

A &quot;token&quot; is just part of a string as defined by the delimiter. So month is token one, day is token two, and year is token three. John Hoarty
jhoarty@quickestore.com

http://www.quickestore.com

 

[Silvano]

to return specifis part of a date you can also use DatePart() function; the function will return the specified part of a date as an integer;

Syntax
DatePart(datepart, date)

datepart can be one of the following strings:

yyyy -- Year
q -- Quarter
m -- Month
y -- Day of year
d -- Day
w -- Weekday
ww -- Week
h -- Hour
n -- Minute
s -- Second

but if your code does not work because what you are saying that the filed in question is not a day/time field, than try using CreateDate() function

CreateDate: #CreateDate(2001, 8, 21)# Sylvano
dsylvano@hotmail.com