Search Tips and Tricks

Login to search and find more tips.

Featured tip

Formatting a date or time field

[QLingo,uProduce,uCreate Print,uStore,uPlan][Steve Couch][30 Mar 2025]

Displaying a date or time in more user friendly ways:

FormatDate(AsDate(|->[field]), "dd MMMM, yyyy")

If the date was 1/1/2000, the above function would result in "01 January 2000".

DateTime string format parameters:

  • d = day as a number without a leading zero
  • dd = day as a number with a leading zero
  • ddd = abbreviated day name
  • dddd =  full day name
  • M = month as a number without a leading zero
  • MM = month as a number with a leading zero
  • MMM = abbreviated month name
  • MMMM = full month name
  • y = year number without leaxing zeros
  • yy = year in two digit numeric format with a leading zero
  • yyy = year in three digit numeric format
  • yyyy = year in four digit numeric format
  • h = hour as a number without leading zero in 12 hour format
  • hh = hour as a number with leading zero in 12 hour format
  • H = hour as a number without leading zero in 24 hour format
  • HH = hour as a number with leading zer on 24 hour format
  • m = minute as a number without a leading zero
  • mm = minute as a number with a leading zero
  • s = second as a number without a leading zero
  • ss = second as a number with a leading zero
  • t = lower case "a" or "p"
  • tt = lower case "am" or "pm"
  • T = upper case "A" or "P"
  • TT = uppercase "AM" or "PM"

Submit a tip

Do you have a useful tip to share? We'd love to hear it! Simply use the Feedback form to submit a tip and we'll add it here to help the XMPie community.