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

[SachAccess]

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

 

[SachAccess]

Hi,
I got my answer, format = medium date.
Thanks a lot.

 

[Minty]

Personally, I would avoid doing that on the table (if you have?) Do it on the forms that display the data.

 

[SachAccess]

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]

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]

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]

That sounds a little strange - are they stored as text, rather than dates?

 

[SachAccess]

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.

 

[CJ_London]

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]

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.