Date modification

[gerles]

I need to get the current date and put it into the following format:
yyymmdd tttttt

I then need to subtract 24 hours from it and so that I can use that time for an SQL query.

Any help would be greatly appreciated!
Thanks,
Gabe

[kadghar]

I need to get the current date and put it into the following format:
yyymmdd tttttt

I then need to subtract 24 hours from it and so that I can use that time for an SQL query.

Any help would be greatly appreciated!
Thanks,
Gabe

Hi there, this might be of help:

Format(Date + Time, "yyyymmdd ttttt")
Format(Date + Time - 1, "yyyymmdd ttttt")

[Killer42]

What version of VB? In VB6, you can use Now to return the current date and time in one go.

[Mohan Krishna]

Hi GERLES

This might help you...

Text1.Text = Format(Date + Time, "YYYYMMDD HHMMSS")
or
Text1.Text = Format(Now, "YYYYMMDD HHMMSS")

ALL THE BEST!

[Killer42]

Text1.Text = Format(Now, "YYYYMMDD HHMMSS")

Actually, minutes are "N" not "M". Gotta watch that...

[Mohan Krishna]

Actually, minutes are "N" not "M". Gotta watch that...

Hi KILLER42!

It is working in both ways! Why?

[lotus18]

Hi KILLER42!

It is working in both ways! Why?

Yes. Killer is right. MM for month and NN for minutes.

[Killer42]

Yes. Killer is right. MM for month and NN for minutes.

Yes, you have to be careful or you'll find that the minutes are always 11 (or whatever), because it's actually showing the month.