INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: need smartlist to indicate all files from month10 2005  (Read 1677 times)

bytestar

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1286
  • Alpha/Betatester
need smartlist to indicate all files from month10 2005
« on: November 11, 2005, 06:10:38 pm »

I need a smartliste with the following function
indicate simply all files from the month 10 in the year 2005

I have meant that would in such a way function

[Date (year)]=2005 [Date (day)]=1-31 [Date (month)]=10 ~nodup=[Artist],[Name]

please help !
Logged
Official Microsoft © product tester.
Download the latest language file https://1drv.ms/u/s!AnQ3L_bTnnzv4otXL9-G4rUj9wX6Tw?e=TLGgjb (is constantly updated)

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9124
Re: need smartlist to indicate all files from month11 2005
« Reply #1 on: November 12, 2005, 02:17:58 am »

[date (year)]=2005 [date (month)]=november

will get you what you want.

bytestar

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1286
  • Alpha/Betatester
Re: need smartlist to indicate all files from month11 2005
« Reply #2 on: November 12, 2005, 04:54:02 am »

[Date (year)]=2005 [date (month)]=october [Media Type]=[Audio]

does is not for me !

date must be taken from the file date, not from the album date!

please help me !
Logged
Official Microsoft © product tester.
Download the latest language file https://1drv.ms/u/s!AnQ3L_bTnnzv4otXL9-G4rUj9wX6Tw?e=TLGgjb (is constantly updated)

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9124
Re: need smartlist to indicate all files from month10 2005
« Reply #3 on: November 12, 2005, 07:52:41 am »

OK, so, by file date, you mean date modified or date created? tweak the following to suit (I used modified)

[date modified] seemed a little tricky to work with, though I did just skim quickly through some things and stopped when I landed a working option. There are deffo other ways of achieving this, I used the following viewscheme:



"modified year" is a database expression: formatdate([date modified],yyyy)

"modified month" is also an expression: formatdate([date modified],MMMM)&DataType=[Month]

resulting in:



Is that any better now?

bytestar

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1286
  • Alpha/Betatester
Re: need smartlist to indicate all files from month10 2005
« Reply #4 on: November 12, 2005, 09:04:43 am »

thanks exactly that is it which I needed  :D

I am too probably stupid for it!  :(
Logged
Official Microsoft © product tester.
Download the latest language file https://1drv.ms/u/s!AnQ3L_bTnnzv4otXL9-G4rUj9wX6Tw?e=TLGgjb (is constantly updated)

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9124
Re: need smartlist to indicate all files from month10 2005
« Reply #5 on: November 12, 2005, 09:32:56 am »

thanks exactly that is it which I needed :D
you're welcome

I am too probably stupid for it! :(
every one of us gets a touch of 'brain fade' now and again. 'stupid' is way too harsh.
your english is far better than my german ;)

Bluesman

  • Regular Member
  • Junior Woodchuck
  • **
  • Posts: 71
Re: need smartlist to indicate all files from month10 2005
« Reply #6 on: November 12, 2005, 07:29:27 pm »

I chose date created as I was looking for a way of keeping track the more recent files from the older ones. Thanks for putting me onto this, I've never dabbled in view schemes until now.
I also added a 'CREATED DAY' to the scheme, ie,  formatdate([date created],day)
Logged
Is there any other music besides Blues?
Pages: [1]   Go Up