I have 2 sets of Date fields(datFrom, datTo, datFrom1, datTo1) in a form. My user can enter any dates into the 1st set of fields, or 2nd set of fields, or both.
they can enter "28/10/99" in datFrom field, and "30/10/99" in datTo field, then they also enter again "02/11/99" in datFrom1 field, and "04/11/99" in datTo1 field.
So I have a view to show all the dates that my user entered. However, in my view I have only 1 date From column and 1 date To column. How am I showing 2 sets of date fields in the same date From & date To columns?
I have the following formula in the date From column:
DateList := @Explode(@Text(datFrom) + "-" + @Text(datTo): @Text(datFrom1) + "-" + @Text(datTo1));
@TextToTime(@Text(DateList) + " 08:30 A.M.")
And currently I put the following formula in the date To column, which I think it may caused the inaccuracy:
@If(@Text(datTo1) = ""; datTo; datTo1)
However, the view doesn't show the dates correctly.
Could someone help me? It's quite urgent..... pls help.....