Print

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

[EpF]

How does MC11 format [Date Imported]?  I'm trying to use IsRange([Date Imported]),40320-10080) in an expression, and it's not working 

(it doesn't work reversing the numbers either)

[EpF]

Just realised I had a comma where I shouldn't have - it's not returning a syntax error now, but it still doesn't give me the right result...

[Matt]

All dates are floating point numbers representing the number of days since 1900.  Negative numbers are supported.

We need to add some helper expression functions to make dates easier to work with.  Until then, FormatDate(...) may let you do some of what you want.

[EpF]

Thanks a million, Matt; that explains a lot..  I had to laugh, cause I would never have figured that out, although I got the expression to work well enough in the end; this is what I did:

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

I wanted to tidy up my date imported list so it wasn't miles long, so I experimented with numbers until I got this.

We need to add some helper expression functions to make dates easier to work with.

Would these helper expressions allow the date to be calculated from the current date, so that, in the expression above, the amount of time where the date is given in detail always stays the same?   

Thanks again.

[EpF]

Just thought of something else; it would be cool if there was some way of inverting the sorting in a View Scheme column, so that most recent dates were at the top...

 

[glynor]

~sort=[Date Imported]-d

"-d" (for decending I suppose) reverses sort order.

[EpF]

~sort=[Date Imported]-d

"-d" (for decending I suppose) reverses sort order.

Standard search parameters don't work in Advanced Expressions:

http://www.jrmediacenter.com/DevZone/DBExpressions.htm

[hit_ny]

~sort=[Date Imported]-d

"-d" (for decending I suppose) reverses sort order.

EpF asked if it was possible to reverse sort the contents of the view scheme column.

The above sorts the contents below the viewscheme columns (if i'm not mistaken).

im on MC 10 ..so not sure if this works in MC 11.

[EpF]

The above sorts the contents below the viewscheme columns (if i'm not mistaken).

No, you're not mistaken, but I was looking for something which would sort the viewscheme columns themselves.  Glynor's suggestion sorts the file list only...

[glynor]

Ahh, sorry.  I misread.  I don't think there is a way... 

(I was actually quite shocked that you didn't know you could use the -d option, since you seem to definately be an advanced user otherwise... Now it all makes sense.)

I typically don't use the Column-style view (I prefer the Tree-View style with "populate tree" selected), so when you said column, I assumed you meant the columns (IE. Name, Media Type, etc) in the Grid view (the pane below your columns where the actual files are listed).

[EpF]

(I was actually quite shocked that you didn't know you could use the -d option, since you seem to definately be an advanced user otherwise... Now it all makes sense.

 

[hit_ny]

No, you're not mistaken, but I was looking for something which would sort the viewscheme columns themselves.  Glynor's suggestion sorts the file list only...

Ahh...this feature has been requested for a long time, maybe they introduce it in v12.