Bharath V Posted January 8 Share Posted January 8 # Sample Case registration Library (sqldf)inp<-data.frame()inp<- CaseRegTableinp_int=inp%>% filter(between(inp$Follow_up_Receipt_Date,startdate,enddate))inp<-sqldf(“select Case Number,Follow-up_seq_Num,Product Name,Initial_or_Follow_up,Follow_up_Receipt_Date,Country”)Inp<-unique(inp)finalsampleddata<-data.frame()grplist= unique(inp$Case_ID), I m used this script for create the Case_reg_sample data ,Assign the input and output parameters as per the below Screenshot, But when im filtering the start and end date. (Example start date:- 12/5/2023 to End Date:- 1/5/2024), But filtered data will shows only 12/4/2023 to 1/4/2024. Here Follow_up_Receipt_Date Data type is DateTime, start and end date Datatype is Date. Please help me out for this issue Link to comment Share on other sites More sharing options...
Gaia Paolini Posted January 8 Share Posted January 8 could it be that 12/4 is interpreted as the 4th of December or the 12th of April, in different places? Link to comment Share on other sites More sharing options...
Bharath V Posted January 8 Author Share Posted January 8 4th December Date format is mm/dd/yyyy Link to comment Share on other sites More sharing options...
Gaia Paolini Posted January 8 Share Posted January 8 The problem seems generated by your data function, not Spotfire native filtering. The statement: inp_int=inp%>% filter(between(inp$Follow_up_Receipt_Date,startdate,enddate)) seems to correctly filter between startdate and enddate.However, I don't know what the input and output are, so without a sample dxp so I can see how the data function is defined with respect to the data, I cannot help further. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now