Date and Text as default

[Melaz29]

I tried searching everywhere and cant seem to find an answer to this one...

Is it possible to have a default value in a table which would be current month and year + text? Eg. mm/yy "text"

=now() & "text"
is fine but I need to format the date to mm/yy and cant seem to get it right.

eg. 08/06 Lease Payments

Also is there a way to do it for previous month, so if processing today it would give 07/06 Lease Payments?

Thanks in advance!

 

[mhartman]

Hello:

Yes, that is possible: In the Format section of your date control, Put the below formula:
'
dd/mm" Lease Payments"
'
I tested this and it works.
Regards
Mark

 

[Melaz29]

In the words of a work collegue....BRILLIANT!

Thanks heaps

You are a star!

 

[neileg]

This works but I'm not sure that it's good design. Data stored should be atomic, i.e. reduced to the simplest meaningful components. It seems to me that you are storing two pieces of data in one field. It would be preferable to store this as two fields. You can always add them together any time you need to.

 

[mhartman]

Hello Melaz29

Good luck with this.
Regards
Mark