Date variables not being recognised as integers

[divsnair08]

Hi Jonathon, I read in some online forums that jamovi does not recognize date and time variables as yet but if they are formatted as date in the source data (eg in excel) then they are converted to an integer calculated as the number of days from 01-01-1970? and the date value in dd-mm-yyyy format is retained as a label.
Is this correct? I have an excel data set with dates in two variables DTSPTMCOL and DTTRTSTRT (attached) but they are recognized as ID variable in the cloud version and desktop solid version 2.3.28. Therefore I am not able to do any calculations like the interval between the two dates.
Is there any way that I can identify these as date variables and perform simple calculations using them?
Regards
Divya
date_github.xlsx

[jonathon-love]

hey,

i think a solution here might be a date parsing function ... that shouldn't be too difficult to add.

stay tuned.

[jonathon-love]

i've added two functions DATE() and DATEVALUE() to the computed variables. i've pushed these changes to the cloud version. take a look and tell me what you think. DATEVALUE() is analogous to the function in excel ... DATE() does the opposite of DATEVALUE() ... converts an integer to a date string.

if you're happy with these, i'll push them out in the next version.

[divsnair08]

Hi Jonathon, this works and serves my purpose. Thanks. Can you tell me when can I expect the next solid version release? A few updates that you made recently in response to my queries will be useful for students in a course I will be teaching in July and it would be good to know when they can expect the new features to be available on the solid release.

[jonathon-love]

OK, this will come out in the 2.5.8 ...

we currently have one show stopper which prevents us from making the 2.5 solid, which is here:

#1506

so far i haven't been able to find any information on it.

but the 'current' is quite 'solid' (its what we use for the cloud version you'll notice), so either way i would direct students to use the 'current'.

[divsnair08]

Noted. Thanks Jonathon. All the best with 1506.