Help: What is code for calling today's date

[ashishg]

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.

Codice: Seleziona tutto

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

I'd like to be able to us today's date. So code should look something like

Codice: Seleziona tutto

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

I think it should be something easy but I can't find in script help file. Thanks.

[raybeau528]

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

Ray

[ashishg]

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

[Teknojnky]

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.

[Peke]

I must confess that I do not understand request/question

[MoDementia]

Looking for this I think

Codice: Seleziona tutto

    LastExportDate = Cdbl(Now)

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