Format Year With Leading Zero? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)

Topic

New Reply

The following command is retruning 3, I need it to return 03

Thanks, John

Me.strYearFrom = Format(Date, “yy”) – 1 ‘ 03

Reply | Quote

Replies

I tryed: Me.strYearFrom = Format(DateSerial(2004 – 1, 3 – 1, 1 – 1), “yy”)

It returned 03, but I’m not sure of the gotchas with this. Those more in the know will have to comment.

You could also try: Me.strYearFrom = Right(DatePart(“yyyy”, Now()) – 1, 2)

Anyone?

Reply | Quote

I tryed: Me.strYearFrom = Format(DateSerial(2004 – 1, 3 – 1, 1 – 1), “yy”)

It returned 03, but I’m not sure of the gotchas with this. Those more in the know will have to comment.

You could also try: Me.strYearFrom = Right(DatePart(“yyyy”, Now()) – 1, 2)

Anyone?

Reply | Quote

Try

Me.strYearFrom = Format(DateAdd(“yyyy”, -1, Date), “yy”)

Reply | Quote

Try

Me.strYearFrom = Format(DateAdd(“yyyy”, -1, Date), “yy”)

Reply | Quote

How about using the Year() function something like:

Me.strYearFrom = Right(Year(Date)-1,2)

Reply | Quote

They all worked

Thank you

Reply | Quote

They all worked

Thank you

Reply | Quote

How about using the Year() function something like:

Me.strYearFrom = Right(Year(Date)-1,2)

Reply | Quote