Threaded Mode | Linear Mode

***Coruja*** · 11-18-2016 02:53 PM

sphere already store the account first/last connection date (<ACCOUNT.FIRSTCONNECTDATE> and <ACCOUNT.LASTCONNECTDATE>), so you must compare these 2 dates and convert it to an "readable" value, which probably the best format will be "X days"

eg: to compare dates 2016/05/10 and 2016/08/10, you must convert both dates into days using the formula: (year * 365) + (month * 30) + days

2016/05/10 = (2016 * 365) + (05 * 30) + 10 = 736000
2016/08/10 = (2016 * 365) + (08 * 30) + 10 = 736090

736090 - 736000 = 90, so the interval between these dates is 90 days

on sphere scripting it will be something like this:

Code:

[FUNCTION GetAccountAge]

return <eval <ConvertToDays <ACCOUNT.LASTCONNECTDATE>> - <ConvertToDays <ACCOUNT.FIRSTCONNECTDATE>>>

[FUNCTION ConvertDateToDays]

ARGS=<EXPLODE : /, <ARGS>>  // this will explode the date "yyyy/mm/dd HH:mm:ss" into "yyyy,mm,dd,HH,mm,ss", making it easy to get values using ARGV[0], ARGV[1], ...

return <eval (<ARGV[0]>*365)+(<ARGV[1]>*30)+<ARGV[2]>>

so with this code you will be able to get the account age using something like "SYSMESSAGE Your account age is: <GetAccountAge> days"

Threaded Mode \| Linear Mode Age count
Author	Message