Impact of Floor() when reading date fields from QVD...please advise
Thanks for your time - I have an app where we read the data from QVD and there are many date fields which are in MM/DD/YYYY format in the QVD but for some reason they have used date(floor(field),'MM/DD/YYYY') again the QVW file where the read from QVD happens - does this impact as we have 3.5M records reading from QVD
should I take off the floor() - when I pull the date field into list box from the QVD they are showing up on the right hand side of the list box - thanks again for your time
Re: Impact of Floor() when reading date fields from QVD...please advise
floor() is used on dates to remove any time value (which is a fraction) from the field. If your dates are already whole numbers, floor() is unnecessary and will slow down your reload. You can confirm if they are already whole numbers by loading the field, put in a listbox and change the number format to timestamp. If they all show 12:00 AM they are good as is.