Liveware Publishing Support Forum

Hi! I am using Xbase ver12 on Foxpro data (MOM ver7).____I need to change a buch of reports from date query to datetime query.____If a user enters a date the current ctod(riparam("inputstart")) needs to be changed to provide datetime. I see lots of functions to convert datetime to date or time but don^t see how to convert a date to datetime (at 12:00:01 am time).____Any tips would be appreciated!____Brian

Your best option is to use the CTDT() function with a character representation of the date or date/time. For instance:____CTDT("07/15/2011 12:00:00 am") returns the datetime value of this character field. Similarly, passing in the character date by itself will work and R&R will add the 12:00:00 am time.