ISDBSongData::LastPlayed: Difference between revisions
Jump to navigation
Jump to search
| Line 13: | Line 13: | ||
Don't forget to take into account if using SQL with MM dates, to adjust for timezone differences between sqlite: | 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) | Now = (JulianDay('now','localtime')-2415018.5) | ||
LastTimePlayed = JulianDay(LastTimePlayed) | LastTimePlayed = JulianDay(LastTimePlayed) | ||
These are for SQL, not for the 'date' object. | These are for SQL, not for the 'date' object. | ||
Revision as of 21:13, 1 February 2008
CoClass SDBSongData, Interface ISDBSongData
Property Get/Let LastPlayed As Date
Property description
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.
