Date Format

[Akchayan]

Hello everyone,


I would like the date to be printed in this format: "YYMMDD". For example, today's date: "220921".
Is it possible to change this here?




Thanks for the help!

[ranman256]

Don’t put it in the table,
do it in the query or report:
qry: forrmat(field,”yymmdd”)

rpt: set format property same, yymmdd

[xps35]

Just try it!

[Akchayan]

Don’t put it in the table,
do it in the query or report:
qry: forrmat(field,”yymmdd”)

rpt: set format property same, yymmdd

Where do i write the code for "rpt: set format property same, yymmdd", into vba right?

[ArviLaanemets]

Use a query as Source of report. In this query, have a field formatted as adviced above, i.e. something like

SELECT field, field2, ...,  YourDateField, Format(YourDateField,"yymmdd") AS YourDateString, ... FROM YourTable ..."

In report, use the field YourDateString do display formatted date.

[Welshgasman]

Where do i write the code for "rpt: set format property same, yymmdd", into vba right?

No, in the same property of the control in the report?

[mike60smart]

Hi

No, on the Report in Design View you would select the Control "AngebottNr" and then change the Properties of the Control as specified.

[Akchayan]

I don't quite understand because I want today's date. So I always want to output the current date in the format "yymmdd" and I don't quite understand how I have to do that with the code snippets from you.

[ArviLaanemets]

... I always want to output the current date in the format "yymmdd"...

SELECT ... FORMAT(DATE(),"yymmdd") AS ReportDate,  ...

[Akchayan]

I have a report, this desired output should come in a text field, can't I do this directly in the text field?

[Welshgasman]

I have a report, this desired output should come in a text field, can't I do this directly in the text field?

Yes, as you tried in the table?
Set the controlsource to =Date() or whatever your Date() is in your language
Then set the format as desired