LastExportDate = Cdbl(Now)

Looking for this I think
[code] LastExportDate = Cdbl(Now)[/code]

but you might have to add/subtract 26k from it to match MM

I have done the code before but can't remember which script :(

Bex knows it off by heart ;)

I must confess that I do not understand request/question :oops: :-? :(

you should be able to delete it by editing the initial post and checking the box for delete, but really there is no need as perhaps someone else may have the same question.

Thanks. Problem solved. Pls delete this thread as I cannot find a way to do so.

You probably need to use the VBscript DATE function and related functions (DateDiff, DatePart, etc).

Ray

itm.Custom3 = ((itm.PlayCounter - 1) * 100) / (itm.LastPlayed - itm.DateAdded)

itm.Custom3 = (itm.PlayCounter * 100) / ([b]<today>[/b] - itm.DateAdded)

Noob alert: please help.

I am trying to write a simple script that will give me play counter per 100 days. I am using it to list my favourite songs. I am currently using LastPlayed so that play count per 100 day at date of last played is computed.
[code]itm.Custom3 = ((itm.PlayCounter - 1) * 100) / (itm.LastPlayed - itm.DateAdded)[/code]
I'd like to be able to us today's date. So code should look something like
[code]itm.Custom3 = (itm.PlayCounter * 100) / ([b]<today>[/b] - itm.DateAdded)[/code]
I think it should be something easy but I can't find in script help file. Thanks.