Date format in Arcade gives wrong results

kirken

Hi! I'm trying to understand how to generate dates using Arcade but it's quite confusing. 

1. Why does this code  

return Date(2020,11,02);

 return a result : 01.12.2020 22:00:00 ???? 

I get very weird results when trying to use this function 😞

2. Then again, when trying to convert from string I get better results:

var year = Year(`20201102`); //02.11.2020 -> November 2, 2020
var month = Month(`20201102`);
var day = Day(`20201102`);
return Date(year, month, day, 0, 0, 0, 0);

returns 01.11.2020 22:00:00 which is almost correct, but still 1 day less than correct

3. How to get rid from minutes - hours- second ?

very confused

thanks

XanderBakker

Hi @kirken ,

@KenBuja answered your first question indicating that the month is 0 based (November would be represented by 10)

For the second question, I notice a couple of things. The Year, Month, and Day functions according to the documentation require a date to extract these values. You provide a string. Also, you used the names of functions for your variables and you should be careful about that. The fact that you got a result baffles me a bit, but I would not recommend taking this road. 

If you have a text that represents a date, you will probably have to extract the different parts, convert them to numbers and then provide these numbers to the Date function correcting the month value for being 0-based.

var datetext = '20201102';
var y = Number(Left(datetext, 4));
var m = Number(Mid(datetext, 4, 2));
var d = Number(Right(datetext, 2));
Console(y);
Console(m);
Console(d);
return Date(y, m-1, d);

 

Unfortunately, Arcade does not have a strptime() function like in Python which can convert a string to date using a provided patterns... (and yes @DanPatterson in Python this would be a lot easier).