INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: EpF on July 23, 2005, 08:57:58 am

Title: MC Expressions - Date order question...
Post by: EpF on July 23, 2005, 08:57:58 am

Bit of a frustrating little pickle...  What I want is this:

Code: [Select]

If(IsRange([Date Imported],1-38103), FormatDate([Date Imported], yyyy),
If(IsRange([Date Imported],1-38530), FormatDate([Date Imported], yyyy//MM),
FormatDate([Date Imported], MMMM//dd))

So that the last part (the FormatDate([Date Imported], MMMM//dd)) bit) shows up as, eg, July/17.

The problem is that at the moment, when both June and July are being displayed, June comes after July, because that's where it comes alphabetically.  No use of '&DataType=[value]' that I have tried has solved the problem.

Anyone got any ideas what I can do?  Is it solvable with the current implementation of the evaluator? (I guess that last question is for Matt! ;))