« Return to the main article
Hi Jake,
Had a quick thought about the "AM/PM" thing and have found the solution below. The formula will have to be put into a Text Field or Computed Text Area, as the value it generates is not a valid date!
now := @Now; day := @Select(@Weekday(now); "Monday"; "Tuesday"; "Wednesday"; "Thursday"; "Friday"; "Saturday"; "Sunday"); month := @Select(@Month(now);"Jan"; "Feb"; "Mar"; "Apr"; "May"; "Jun"; "Jul"; "August"; "Sep"; "Oct"; "Nov"; "Dec"); day + " " + @Text(@Day(now)) + " " + month + ", '" + @Right(@Text(@Year(now)); 2) + " " + @Text(@Time(now); "T0") + " " + @If(@Hour(now) < 12; "AM"; "PM")
Later
Patrick
Hi Jake,
Had a quick thought about the "AM/PM" thing and have found the solution below. The formula will have to be put into a Text Field or Computed Text Area, as the value it generates is not a valid date!
now := @Now; day := @Select(@Weekday(now); "Monday"; "Tuesday"; "Wednesday"; "Thursday"; "Friday"; "Saturday"; "Sunday"); month := @Select(@Month(now);"Jan"; "Feb"; "Mar"; "Apr"; "May"; "Jun"; "Jul"; "August"; "Sep"; "Oct"; "Nov"; "Dec"); day + " " + @Text(@Day(now)) + " " + month + ", '" + @Right(@Text(@Year(now)); 2) + " " + @Text(@Time(now); "T0") + " " + @If(@Hour(now) < 12; "AM"; "PM")
Later
Patrick