Dates not being read in correctly from R code

aazariaz
Level 1
Dates not being read in correctly from R code

Hi!

I'm currently facing an issue where we are using R code to calculate the difference between two date values in days.  The code is working fine when we run it in R Studio, but when we put the recipe into Dataiku it seems to not read in the date values correctly.  I've attached a screenshot of an example of our expected output vs the type of output we're seeing in Dataiku, and you can see that the date field is being read in as a double instead of a date for some reason. 

In the input data, the date is being read in as a string, but in the R code we formatted it as a date and still got the expected output.  However, we've now modified the R code to exclude weekends from the calculation, and for some reason this caused the issue to appear.  Is there anything we should be changing in the R code or in Dataiku to correct this?

Thank you!

 

0 Kudos
1 Reply
TianniL
Dataiker
Dataiker

Hi Aazariaz,

I think your actual date format is epoch, instead of date. Maybe you can convert it to date in R

as.POSIXct(date_in_epoch_format, origin="1970-01-01"))

or via a prepare recipe. Hope this helps!

0 Kudos
Labels (4)
A banner prompting to get Dataiku DSS
Public