Axaptapedia is now maintained by AgileCadence For more information please click here.

QueryValue function

From Axaptapedia
Jump to: navigation, search

The queryValue will return the contents of any variable in a form which is suitable for use as a literal in a query range

The following rules are applied:

Dates are return as "d-m-yyyy". For example, 1st June 2006 returns "1-6-2006"

Strings are returned with certain characters "escaped". For example, "dog's world*" returns dog's\ world\*

Times are returned as integers, for example 10:25:17 returns 37517