Date formatted as text

[benderulz]

Is there a way to format Now()-1 as text used in a query criteria?

example 2011-10-26 07:30:00 would show as 20111026073000

 

[BigRed1212]

Now()-1 is a day ago.

So if now() is:
10/26/2011 2:11:40 PM

and now()-1 is:
10/25/2011 2:11:40 PM

then I would think now()-1 as a big text string is:
SELECT year(now()-1)&month(now()-1)&day(now()-1)&hour(now()-1)&minute(now()-1)&second(now()-1)

or:
20111025141140

 

[BigRed1212]

Although why you would want to do that and make a date harder to work with I don't know.

 

[SkipVought]

format(Now()-1,"yyyymmddhhnnss")

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Gammachaser]

A little easier:

Select Format(Now()-1,"yyyymmddhhmmss") ...

 

[BigRed1212]

Never done it that way. Good to know.

 

[Gammachaser]

Dangit Skip, you did it again... beat me by seconds!

 

[Gammachaser]

...and I had a typo. "...hhmmss" should be "...hhnnss" as Skip shows.

 

[benderulz]

@BigRed1212 Unfortunately, I'm working with someone else's database that formatted their dates that way. Caused me nothing but problems.

Thanks everyone for your help!

 

[SkipVought]

Next to useless!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}