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"