How do I work with dates and time?

MobileDataNow works with data and time stamps for most common databases.

MobileDataNow uses timestamps to replace the date/time value in a database. The user Input or direct value format must be in this format “yyyy-MM-dd hh:mm” (the time part is optional).

This format works for all Databases except Microsoft Access. If Microsoft Access needs to be used, in the query builder editor the " ' " sign has to be replaced with the " # " around the date/time value. The date/time format in MS Access must be dd/MM/yyyy hh:mm:ss PM/AM.

Current Date/Time replaces date/time when a message is received to any MDN messaging service. (Current Date/Time is not supported by Microsoft Access).

User can also select the date from calendar in query builder.