Hi,
I am facing some problem with displaying days between two dates…
I have a computed field where i have given the below formula and the start and end dates fields r text fields.when i select start date is 10/02/2015 and end date as 10/03/2015… output is showing only 2 dates i.e 02/10/2015 and 03/10/2015 which is wrong . It should display the dates from 10/02/2015 to 10/03/2015.
@TextToTime(@Explode(@TextToTime(@text(StartDate)+“-”+@text(EndDate));“;”))
Please help me regarding this…
Subject: Display dates between two dates
That’s what you’d expect if the date settings on the machine running the code were MM/DD/YYYY (it’s reporting October 2 and 3, 2015, just like you asked). It appears that you want the DD/MM/YYYY results instead (February 10 to March 10) – that should happen automatically if the fields in question are all working with real dates, and none of the values are accidentally stored as formatted text. Date/text conversions are never a good thing, but there’s a very limited opportunity for settings to change within the execution time of a single line of code, so suspect that there’s something wrong with the source dates.