Date Display... The bank wants it that way...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey all, thanks for listening.

My brain teaser is that I need to show a date when I print a Cheque.

The issue is the bank has 8 spots on the CQ ... D D M M Y Y Y Y

There can be no slashes or dashes.... 9 point font... and no
moving(shifting) of Numbers.

Probably as I finish writing this I will think of an answer, but if anyone
can come up with a way to do this I would appreciate it.
 
MaxZ said:
Hey all, thanks for listening.

My brain teaser is that I need to show a date when I print a Cheque.

The issue is the bank has 8 spots on the CQ ... D D M M Y Y Y Y

There can be no slashes or dashes.... 9 point font... and no
moving(shifting) of Numbers.

Probably as I finish writing this I will think of an answer, but if
anyone can come up with a way to do this I would appreciate it.
Click to expand...

Format([DateField], "D D M M Y Y Y Y")
 
Rick said:
MaxZ said:
Hey all, thanks for listening.

My brain teaser is that I need to show a date when I print a Cheque.

The issue is the bank has 8 spots on the CQ ... D D M M Y Y Y Y
There can be no slashes or dashes.... 9 point font... and no
moving(shifting) of Numbers.

Probably as I finish writing this I will think of an answer, but if
anyone can come up with a way to do this I would appreciate it.
Click to expand...

Format([DateField], "D D M M Y Y Y Y")
Click to expand...

Sorry I just realized that the above does not in fact work.
 
In the end the trick is to create 8 boxes and code each as 1 of the date
values.
half of the answer is to use the mid function and count.

Thanks for the input, it got my brain going
 
Back
Top