Re: Number of week .. on report

PADL(Month(date),'0',2)

-Anders

"Franz Leu" <franz.leu@xxxxxxxxxxxxxxxxxxxxxxx> skrev i meddelandet
news:eJb9FAz%23FHA.3568@xxxxxxxxxxxxxxxxxxxxxxx
> Hi
> I would like to have a print like this on a report:
>
> xxyyzz
>
> xx = month
> yy = day of month
> zz = hour of day
>
> always with fixed length of 2 (trailing 0)
>
> I tried with functions like MONTH(DATE()) .. but could not get to the
> trailing 0 for month 1 to 9. Same for the days. I did not yet try any
> function for the hours.
>
> How can I do that?
> Thanks for your help
> Franz


.

Relevant Pages

  • Re: International Conference on the Phaistos Disk
    ... personal insults. ... You, Franz, are only repeating the same unsolicited old thing day in, ... This is what is usually called spamming. ... And, of course, the report would mention ...
    (sci.lang)
  • Re: Strippinng characters out of excel
    ... We are exporting this report to the tax office and they do not ... accept hyphens in the ss numbers. ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Exclude entry when certain field is blank
    ... when running my report I need to leave out all entries when a ... > certain date field is missing data. ... Prev by Date: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Report Size
    ... When you're back at your new form in Design view, hit F5 to run the ... View the report. ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: Status = Closed
    ... >> Hi - newbie access person here. ... >> records on my report. ... I don't want it showing any records where ... Prev by Date: ...
    (microsoft.public.access.reports)
Loading