ISDBSongData::LastPlayed: Difference between revisions

Revision as of 21:11, 1 February 2008

CoClass SDBSongData, Interface ISDBSongData

Property Get/Let LastPlayed As Date

Some discussion in this thread, in summary use vb datediff() function to compare dates (ie .LastPlayed > x seconds/minutes/hours/days/etc).

Don't forget to take into account if using SQL with MM dates, to adjust for timezone differences between sqlite:

Now = JulianDay('now','localtime'-2415018.5)

LastTimePlayed = JulianDay(LastTimePlayed)

These are for SQL, not for the 'date' object.

@@ Line 10: / Line 10: @@
 Some discussion in [http://www.mediamonkey.com/forum/viewtopic.php?t=25687 this thread], in summary use vb datediff() function to compare dates (ie .LastPlayed > x seconds/minutes/hours/days/etc).
+Don't forget to take into account if using SQL with MM dates, to adjust for timezone differences between sqlite:
+Now = JulianDay('now','localtime'-2415018.5)
+LastTimePlayed = JulianDay(LastTimePlayed)
+These are for SQL, not for the 'date' object.