Trim value

[dada]

Good day to all! I was just wondering if it is possible to trim a value from the database and make an if statement on it.. for example i have a value in my database that's like 09/10/2010.. what i want to do is just get the value of the first 2 numbers and make an if statement like:

if ## = ## then
msgbox "Your month is September"
else if ## = ## then


msgbox "Your month is November"
End If

i hope i made it clear.. please help..

[maximus]

if your field type is Date/Time then you can use:
here [fldTimeStamp] Data type is Date/Time.
Format([fldTimeStamp],"mmmm")

please mark the thread solved if your problem is solved

[maximus]

Format([Name of your Field here],"mmmm")

[weekend00]

Maximus, please show him/her how if the field is text type. show all the code should be better than only an expression.

And maybe he/she doesn't need the if...else.

[dada]

thanks! awesome i have solve my problem now..

[maximus]

Format([YourDateField],"mmmm") can be used even if your date is a text field but in a proper date format like

Example:
Like you date is entered like: 6/5/2010 and the field type is not Date/Time and is Text then also this expression can be use:

but suppose ur date is entered as a text in this format:
652010:

Format(DateSerial(Right([fldTimeStamp],4),Left([fldTimeStamp],1),Mid([fldTimeStamp],2,1)),"mmmm")

here I have used date Serial and Right, Left, Mid Functions to get the required result.