Problems with Date formatting 1

[JLeo]

Hi,

Need some help as i'm stuck with this niggling prob...

I wish to assign the the current day, month and year to 3 seperate variables using:

CurrDay = Day(Date)
CurrMth = Month(Date)
CurrYear = Year(Date)

Looks simple n straightfoward but it returns garbage, after a few inspections, i realised that the 'Date' function returns todays date as 110603(DDMMYY format) and hence it can't recongnise the day, mth or year correctly.

I believe that this should work fine as long as the 'Date' function returns in the DD/MM/YY format. Can anyone advice how to format the date accordingly??

Thanks alot in advance.

 

[EliseFreedman]

Jleo

I think you need to read up on the datepart function. This can be used to extract the individual bits of the specified control.

In your case the function would be as follows

currday=Datepart("d",Now()) where Now() is the current date.

Alternatively you can use the same function that you were using. However, instead of Day(Date), try using Day(Now()).

The Now() function will return todays date

HTH

Elise

 

[JLeo]

Hi Elise,

Jus as simple as that, the 'Now()' function has solved my problem. To think I spent 3 hours trying to get the 'Date' function to work correctly.

A star to show my apprecieation. Thanks.

Cheers

 

[BobJacksonNCI]

NOMB - None Of My Business, but...

On my PC here in New York:

?date
6/13/03

?now
6/13/03 3:07:52 PM

Notice the date portion's are formatted the same.

So I'm wondering if JLeo has European set as his default date format. And if he does, if he ?date and ?now,
do they return different formats?

Just wondering,
Bob