Print

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

[EpF]

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! )