-
date to number
hello all,
in Excel, Dates can be formatted/converted to a single number. Is there a way in AS2.0 to do that?
thanks,
-
Prid - Outing
Umm, you just make a Date object and then use the getTime() function which "Returns the number of milliseconds since midnight January 1, 1970, universal time, for the specified Date object."
Try this code:
Code:
var date:Date = new Date(2015, 03, 03, 10, 20, 30, 400);
trace(date.getTime());
where Date(year, month, date, hour, min, sec, ms)
Hope this helps
I am back, guys ... and finally 18 :P
BRING BACK THE OLD DESIGN!! OR AT LEAST FIX THE AS TAGS
-
Thank you Sir for your help on that.
- The first issue with that method; -ve numbers are obtained for dates before 1970 (<1970).
- One more issue, now, if that same resulted number is needed to be converted back to the same date?
The reason for asking this, to plot data on chart like in excel e.g. (Date vs. any-variable) .
Regards!
-
.
Hi,
Perhaps this might get you further along.
PHP Code:
var dateToGet:Date = new Date(1969, 1, 1, 10, 20); trace("Date: " + dateToGet);
var dateToGetNumber:Number = dateToGet.getTime(); trace("Date number: " + dateToGetNumber);
var numberToDate:Date = new Date(dateToGetNumber); trace(dateToGetNumber + " -> " + numberToDate);
and you might or probably do need to offset it.
PHP Code:
var utcOffset = numberToDate.getTimezoneOffset() * 60 * 1000; var utcNow:Date = new Date(numberToDate.valueOf() + utcOffset); trace(utcNow);
-
.
Hi again,
This might help too.
PHP Code:
var numbers:Array = new Array(128946000000, 468930000000, 770808000000);
var dates:Array = new Array();
for (var i:Number = 0; i < numbers.length; i++)
{
var numberToDate:Date = new Date(numbers[i]);
var offset:Number = convert.getTimezoneOffset() * 60 * 1000;
var convertDate:Date = new Date(numberToDate.valueOf() + offset);
trace(i + ": " + numbers[i] + " -> " + numberToDate);
dates.push(numberToDate);
}
for (var j:Number = 0; j < dates.length; j++)
{
var dateToNumber:Number = dates[j].getTime();
trace("Date to number: " + dates[j] + " -> " + dateToNumber);
}
-
.
Hi,
slight error there, ->
PHP Code:
var numbers:Array = new Array(128946000000, 468930000000, 770808000000); var dates:Array = new Array();
for (var i:Number = 0; i < numbers.length; i++) { var numberToDate:Date = new Date(numbers[i]); var offset:Number = numberToDate.getTimezoneOffset() * 60 * 1000; var convertDate:Date = new Date(numberToDate.valueOf() + offset); trace("Number to date: " + numbers[i] + " -> " + convertDate); dates.push(convertDate); }
for (var j:Number = 0; j < dates.length; j++) { var dateToNumber:Number = dates[j].getTime(); trace("Date to number: " + dates[j] + " -> " + dateToNumber); }
but i'm sure you can get to grips with it
-
Originally Posted by fruitbeard
Hi again,
This might help too.
PHP Code:
var numbers:Array = new Array(128946000000, 468930000000, 770808000000); var dates:Array = new Array();
for (var i:Number = 0; i < numbers.length; i++) { var numberToDate:Date = new Date(numbers[i]); var offset:Number = convert.getTimezoneOffset() * 60 * 1000; var convertDate:Date = new Date(numberToDate.valueOf() + offset); trace(i + ": " + numbers[i] + " -> " + numberToDate); dates.push(numberToDate); }
for (var j:Number = 0; j < dates.length; j++) { var dateToNumber:Number = dates[j].getTime(); trace("Date to number: " + dates[j] + " -> " + dateToNumber); }
Thank you fruitbeard,
This code works great.
Regards!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|