Is it possible to change visible appearance of Date (1 Viewer)

SachAccess

Member
Local time
Today, 11:35
Joined
Nov 22, 2021
Messages
62
Hi,

I have a Date field in my DB. At present date is visible as ‘23-11-2021’.
Is it possible to change visible appearance of date from ‘23-11-2021’ to ’23-Nov-21’.
I tried playing with Input mask setting but realized that am wrong here.

Can anyone please help me this. Thanks
 

Minty

AWF VIP
Local time
Today, 06:05
Joined
Jul 26, 2013
Messages
8,910
Personally, I would avoid doing that on the table (if you have?) Do it on the forms that display the data.
 

SachAccess

Member
Local time
Today, 11:35
Joined
Nov 22, 2021
Messages
62
Hi @Minty sir, thanks, these are reports, will do it on Forms.
Sir which format you would suggest for Dates in Report.

Have a nice day ahead. :)
 

Minty

AWF VIP
Local time
Today, 06:05
Joined
Jul 26, 2013
Messages
8,910
Whatever your end users would like to see!
The same formatting options are available for report controls as forms.

My suggestion was generally, not to mess with formats for anything directly in a table.
 

SachAccess

Member
Local time
Today, 11:35
Joined
Nov 22, 2021
Messages
62
Hi @Minty sir, thanks, the date were not in uniform format in the tables hence I tried to make it uniform.
However will definitely keep your suggestion in mind going forward.
 

Minty

AWF VIP
Local time
Today, 06:05
Joined
Jul 26, 2013
Messages
8,910
That sounds a little strange - are they stored as text, rather than dates?
 

SachAccess

Member
Local time
Today, 11:35
Joined
Nov 22, 2021
Messages
62
Hi @Minty sir, all are stored as Date. But please give me some time, I will re-check.
But 99% am sure that all are stored as Date.
Thanks for the help.

PS - Hi @Minty sir, just re-checked, all are stored as Date only.
 
Last edited:

CJ_London

Super Moderator
Staff member
Local time
Today, 06:05
Joined
Feb 19, 2013
Messages
13,582
the date were not in uniform format in the tables
probably because different formats are used in the tables - I agree with Minty, do not use any formatting in tables. Formatting can hide the real value of the data
 

SachAccess

Member
Local time
Today, 11:35
Joined
Nov 22, 2021
Messages
62
probably because different formats are used in the tables - I agree with Minty, do not use any formatting in tables. Formatting can hide the real value of the data
Sure sir, will remember this point going forward. Thanks for the help.
 

Users who are viewing this thread

Top Bottom