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

[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.

 

[Rick Brandt]

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.

Format([DateField], "D D M M Y Y Y Y")

 

[Rick Brandt]

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.

Format([DateField], "D D M M Y Y Y Y")

Sorry I just realized that the above does not in fact work.

 

[onedaywhen]

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

SELECT FORMAT(FORMAT(date(), 'ddmmyyyy'), '0 0 0 0 0 0 0 0')

Jamie.

--

 

[Guest]

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