Changing date format??

[Zazu]

Ok this is a bit techical question.. maybe there r some Gurus here that can help me. I have this program which prints my checks... due to the recent change in the check format, i need to print the dates in the new format.

How do i change from the old format [ 19/2/08 ] to the new format [ 19 02 08]?

the program is written using Ms Access. Thx

[alfred98]

Ok this is a bit techical question.. maybe there r some Gurus here that can help me. I have this program which prints my checks... due to the recent change in the check format, i need to print the dates in the new format.

How do i change from the old format [ 19/2/08 ] to the new format [ 19 02 08]?

the program is written using Ms Access. Thx

Wah got programme to print cek ah.....I wan I wan!!!:) :)

[Zazu]

Wah got programme to print cek ah.....I wan I wan!!!:) :)

can. give u but must solve date problem first.

[KoChun]

Wah got programme to print cek ah.....I wan I wan!!!:) :)

If can print money, better still.

[alfred98]

can. give u but must solve date problem first.

Must change it in the format first hei!!!

[alfred98]

I think i need it to change the format.....:)

[Zazu]

I think i need it to change the format.....:)

problem is dunno how to change. :D

[KeeOng]

Try Control Panel | Regional Settings and set the date to the one you desire.

Reboot a try again. This will only work if your program is smart enough to take advantage of the system locale format. (I have seen too many dumb programs that just hard code the format. :)

(The above is for Vista, slight variation if you have something else, i.e. XP), hopefully nothing older than that :)

[Zazu]

Try Control Panel | Regional Settings and set the date to the one you desire.

Reboot a try again. This will only work if your program is smart enough to take advantage of the system locale format. (I have seen too many dumb programs that just hard code the format. :)

(The above is for Vista, slight variation if you have something else, i.e. XP), hopefully nothing older than that :)

tat will change all the other program date settings.. i onli want it for the check printing program.

[JC]

MS Access stores the date in US format. But the display and printing is based on the locale as KeeOng pointed out.

[Zazu]

MS Access stores the date in US format. But the display and printing is based on the locale as KeeOng pointed out.

i know that but i wanna print the date without the slashes.. ie 08 02 08 ( no date separator) can or not be done?

[JC]

Assuming that the variable for the date is "zazu"
Crude way to do this...

print date(zazu)
print space
print month(zazu)
print space
print year(zazu)

Perhaps some programming guru here can help with an easier approach... :o

[Zazu]

Assuming that the variable for the date is "zazu"
Crude way to do this...

print date(zazu)
print space
print month(zazu)
print space
print year(zazu)

Perhaps some programming guru here can help with an easier approach... :o

i hv really lost touch in coding any help wud be much appreciated. :)

[JC]

What is the name of your program and do you know if you can change the program in any way?

[Zazu]

What is the name of your program and do you know if you can change the program in any way?

he he.. i wrote that program 10 years ago... surelah know can change... but now v v rusty ade. :)

[Odysseus]

he he.. i wrote that program 10 years ago... surelah know can change... but now v v rusty ade. :)
Zazu, I wish I could help you but I stopped programming 15 years ago :(

JC's logic makes sense but I don't know how to apply it in Ms-Access :(

[alfred98]

I think it will be easier to write a new programme!!:p :p

[Zazu]

I think it will be easier to write a new programme!!:p :p

how to write a program now... dunno how to start ade!! :D :D

[JC]

he he.. i wrote that program 10 years ago... surelah know can change... but now v v rusty ade. :)
Since you wrote it yourself, do you still have the source code?
What programming language did you use?

[daBoss]

is the program purely ms access? if so, send it to me - i can try to have a look at it for you... will pm you the email address to send it to.

[h2o]

is the program purely ms access? if so, send it to me - i can try to have a look at it for you... will pm you the email address to send it to.

ok zaz, now u got the sifu.......

[Zazu]

is the program purely ms access? if so, send it to me - i can try to have a look at it for you... will pm you the email address to send it to.

ok zaz, now u got the sifu.......

thx boss... but i have already solved the problem... it's actually quite simple.. just change the date format at the "report" level... just change the date properties to dd mm yy. (didn't think of it!)

So Dr Alf.. if you wanna hv it i can send it to you but it's around 2Mb plus. And also it's not quite user friendly. But it has served me well for the past 10 years.
Basically you can batch print you checks. I use it once a month to print my checks to the distributors.

[datokuan]

thx boss... but i have already solved the problem... it's actually quite simple.. just change the date format at the "report" level... just change the date properties to dd mm yy. (didn't think of it!)

So Dr Alf.. if you wanna hv it i can send it to you but it's around 2Mb plus. And also it's not quite user friendly. But it has served me well for the past 10 years.
Basically you can batch print you checks. I use it once a month to print my checks to the distributors.

well done.. using a Forum to resolve problem... but Zazu, u realli good.. wan to share but got come with warnings ... user beware... he he he he....:D

[Zazu]

well done.. using a Forum to resolve problem... but Zazu, u realli good.. wan to share but got come with warnings ... user beware... he he he he....:D

sure must cover myself mah.. if not after check issued wrongly... i cannot compensate. :D

[KeeOng]

thx boss... but i have already solved the problem... it's actually quite simple.. just change the date format at the "report" level... just change the date properties to dd mm yy. (didn't think of it!)

So Dr Alf.. if you wanna hv it i can send it to you but it's around 2Mb plus. And also it's not quite user friendly. But it has served me well for the past 10 years.
Basically you can batch print you checks. I use it once a month to print my checks to the distributors.

Bad assumption on my part. Thought this was a compiled commercial program :). I am impressed that you write computer program too :)

[Zazu]

since i am getting all this good and free advice.. one more question.. how do i compile it to be a standalone program?

Any free compiler available?

[alfred98]

Ah!!! Zazu ah!!! How to use the program ah?????Blurrrrrr leh!!!:(

[Zazu]

Ah!!! Zazu ah!!! How to use the program ah?????Blurrrrrr leh!!!:(

must open using Microsoft Access

[KeeOng]

must open using Microsoft Access

Checkout this package: Microsoft Visual Studio Tools for Office, but it is quite costly over here in US. You may be able to get one "much" cheaper over there :)

[Zazu]

Checkout this package: Microsoft Visual Studio Tools for Office, but it is quite costly over here in US. You may be able to get one "much" cheaper over there :)

ok.. will do. I am sure there r some heavily discounted ones here!