How to use an expression in a report

[gbritton]

I have a report that includes a text field containing a date (in text though, not a date type). The date is like '2016-03-24 09:47:00'. The report runs and shows the date properly. Now however, I only want the date portion so I tried to modify that report field by adding an expression:



Left$(myfieldname, 10)

However, now, when I run the report, it shows #Type! where the date used to be.

What am I doing wrong?

[pbaldy]

You would need an = at the beginning for one thing.

[gbritton]

You would need an = at the beginning for one thing.

yes, of course. That is actually what I have coded. (WHen I didn't, I got a different error message). So the actual contents of the expression (copy/paste) are:

=Left$([L1-Last Updated Date],10)

Yet, I still get that funny error.

Any ideas why?

[pbaldy]

And there are values in the field, it's not blank?

Try

=Left([L1-Last Updated Date],10)

Oh, and make sure the textbox doesn't have the same name, which can throw access off.

[gbritton]

So I renamed the field on the report to avoid the name collision and replaced the expression with your variant.

It worked!

[pbaldy]

Yours may have worked too. I forgot about the name thing at first.