Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Tanguero]

I searched some recently imported files through an expression based view scheme using the expressions

FormatDate([Date Imported], yyyy-MM)
and
FormatDate([Date Imported], yyyy-MM-dd)

According to MC, all my files are imported 1905-06-26, 1905-06-27 or 1905-06-28. This is not true. 

Is this a fault or is it a matter of changed syntax?

[JimH]

Did you check the PC's clock?

[Tanguero]

I checked the PC's clock, and it shows the right time.

I may add that the correct import dates should be a number of dates during the last years.

[Tanguero]

I have a similar view scheme using  Date Created with the same problem, the only difference is that there is one more date in the list.

[marko]

I searched some recently imported files through an expression based view scheme using the expressions

FormatDate([Date Imported], yyyy-MM)
and
FormatDate([Date Imported], yyyy-MM-dd)

According to MC, all my files are imported 1905-06-26, 1905-06-27 or 1905-06-28. This is not true. 

Is this a fault or is it a matter of changed syntax?

due to recent changes (assuming that v11.1 is being used) you need to tweak your expressions like so...
FormatDate([Date Imported,0], yyyy-MM)

and

FormatDate([Date Imported,0], yyyy-MM-dd)

then all should be good again.

[Tanguero]

Thank you, Marko!

That fixed it. Not that I understand how this is related to "raw data" versus "data formatted for display" as described at http://www.jrmediacenter.com/DevZone/DBExpressions.htm , but you solved my problem. I guess I will understand if I give it the necessary time including some background reading.

/Tanguero