INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: Tanguero on January 16, 2006, 12:08:04 pm

Title: Import date problem
Post by: Tanguero on January 16, 2006, 12:08:04 pm

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?

Title: Re: Import date problem
Post by: JimH on January 16, 2006, 12:15:03 pm

Did you check the PC's clock?

Title: Re: Import date problem
Post by: Tanguero on January 16, 2006, 12:22:19 pm

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.

Title: Re: Import date problem
Post by: Tanguero on January 16, 2006, 12:28:56 pm

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.

Title: Re: Import date problem
Post by: marko on January 16, 2006, 01:02:52 pm

Quote from: Tanguero on January 16, 2006, 12:08:04 pm

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.

Title: Re: Import date problem
Post by: Tanguero on January 16, 2006, 01:26:43 pm

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