Hi Experts,I am displaying the @Today results as a time stamp on a form when the user hits a button. I want to have it displayed as dd/mm/yy instead of d/m/yyyy. Particularly would like the year to be only 2 digits instead of 4 but would be nice if the day and month were also always 2 digits. This is formula language…
Thanks, Paul
Subject: Make sure your field is a date time field
then you can use the Field Properties on the field to change the display format.
Subject: Thanks but I must not have been clear enough
Hi Carl,
Thanks for you help but not exactly what I was looking for.
The code I have now produces the string: "01/05/2018: Gaschke: "
What I want is for it to produce: "01/05/18: Gaschke: "
Here is my code: FIELD Comments := @Text(@Today) + ": " + @Right(@Name([CN];@UserName); " ") + ": ";
Is there a easy way to do this?
Thanks, Paul
Subject: Take a look in designer help
and look at: @month, @day, @year and @right
using them together and @text you can build your string the way you want.