April 28, 2009 at 8:59 am
So I bind a field to a TextBox, go to Text Box Properties, click on Number, click on Date and no matter which dateformat I choose it still displays in the same date format!!!
The only way I can force it to change the date format is to use an Expression in the value of the textbox using =FormatDateTime(!Field.Value,"vbcrap") which doesn't give me the format I need.
What am I doing wrong?
May 3, 2009 at 9:03 pm
Is your date field actually a datetime or date field or is it a string that looks alot like a date?
I created a report that connected to a table with a datetime field and with a string representation of the datetime field. The proper datetime would format to whatever date formatting I chose, but the other, which is just a string, stayed as it appears in the table.
If it's a string that you are using, then format(, "dd-MMM-yy") would format 30-Apr-09 for example. You'd need to put that in your field expression.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply