DateTime Formula

I am presently trying to create a datetime formula that will populate at the time when the report is printed. The format for this will be 2109201502:15PM . So basically DDMMYYYYHH:MMTT. I have been beating my head off a wall because if I get the date and time combined I can't get it to leave the space out after the minutes where its formating it as DDMMYYYYHH:MM TT. Anything I bring into the formula wants to add a space where I don't want the space.
Jason RussellAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rgonzo1971Commented:
maybe

DDMMYYYYhh:mmTT

or maybe use two functions and concatenate them
one with
DDMMYYYY
the other with
hh:mmTT

Regards
Mike McCrackenSenior ConsultantCommented:
Try it this way

CStr(CurrentDateTime,"ddMMyyyyHH:MMtt")

mlmcc

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bdreed35Commented:
Certain letters in the format string are case sensitive.  Capital M's are for months and lowercase m's are for minutes.  Capital H's mean 24 hour clock while lower case h's mean 12 hour clock.  You will need a mlmcc's formula with some minor changes:

CStr(CurrentDateTime,"ddMMyyyyhh:mmtt")

Open in new window

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.