A problem with dates

Zaboss · Posted: Mon Jan 10, 2005 8:05 pm Post subject: A problem with dates

I have discovered a strange bug in one of my applications.

The user is supposed to do some jobs, for which he has a deadline, which is the 7th of every month. After that day, he shouldn't be able to perform some actions. The code is:

gruff · Posted: Mon Jan 10, 2005 8:51 pm Post subject:

Hi

A good starting point is to check that you have a

Session.LCID defined in the the global.asa.

Otherwise date formats take the default of the Server which may change!

G

Zaboss · Posted: Tue Jan 11, 2005 7:16 am Post subject:

I don't think it has somethin to do with this. But onŁy with December = 12 and January = 1 and 1 < 12 while in any otherr cases the previous month = (current month) - 1.
_________________
Zaboss
Design for web/print

gruff · Posted: Tue Jan 11, 2005 8:03 am Post subject:

Maybe,

I notice that you have a "7" which implies that 7 is a string which is different from 7.

Zaboss · Posted: Tue Jan 11, 2005 8:46 am Post subject:

It doesn't work either, because it stil compares 1 with 12. I need somehow to get the year in this picture. The problem is that I want ot avoid a big if/else here.
_________________
Zaboss
Design for web/print

Paul Creedy · Posted: Tue Jan 11, 2005 12:29 pm Post subject:

What you mean is Jan 2005 is AFTER Dec 2004?

You will need to bring the whole date into the formula so that it knows which year you are refering to:

Dec 2004 is AFTER Jan 2004, but Jan 2005 is AFTER Dec 2004

etc.
_________________
Paul Creedy
Admin@RhonddaCynonTaff.com

www.TreorchyComputerClinic.co.uk | www.PrincessHouse-Christine.co.uk | www.RhonddaCynonTaff.com | www.completerugby.com | www.richieburnett.com | www.TDGS.org.uk | www.RCTBroadband.com| www.CPDCymru.net |

gruff · Posted: Tue Jan 11, 2005 12:30 pm Post subject:

Oh I see what you mean, I should have fully understood the problem before answering.......

Why not include the year in the comparision too? But put it first.

0412 and 0501

I am sure that there must be a better way....... Smile

Nick · Forum Moderator Joined: 18 Jun 2002 Posts: 3635

Yes, I think using the year is the best solution here.

After years of being pushed around by disagreeable dates when moving sites between servers/locations/date formats, I now use a tried and tested method of "yyyymmddhhmmss". Stored as an integer in the database, simple less than/greater than calculations can be performed, and it makes selecting records between two dates very easy.

I have one function to create an integer in the above format, and another couple to read them and format the number into whatever format I need. Maybe a useful article for Home@OH. The beauty of it is that it works no matter what date format the server uses.
_________________
Nick Dunn
Nick Dunn

Paul Creedy · Posted: Tue Jan 11, 2005 1:27 pm Post subject:

I do similar. I still store in the Date Field type not an integer, but I throw the date at the field in the format yyyy/mm/dd this way you can be guarenteed that whatever server or local you are in the date will get stored correctly.

ASP incorrectly reformats dates when you are using cross local servers. Server in US, user in UK etc. Using the above it works whatever.

You can also get the difference between two dates by using the DateDiff function.
_________________
Paul Creedy
Admin@RhonddaCynonTaff.com

www.TreorchyComputerClinic.co.uk | www.PrincessHouse-Christine.co.uk | www.RhonddaCynonTaff.com | www.completerugby.com | www.richieburnett.com | www.TDGS.org.uk | www.RCTBroadband.com| www.CPDCymru.net |

Mark Voss · Posted: Tue Jan 11, 2005 1:30 pm Post subject:

Nick · Forum Moderator Joined: 18 Jun 2002 Posts: 3635

Zaboss · Posted: Tue Jan 11, 2005 2:00 pm Post subject:

Actualy, it's not from database, but from a text file over which i have but little control. So I have to deal with it as it is. I have found a simple workarround:

Nick · Forum Moderator Joined: 18 Jun 2002 Posts: 3635

Zaboss · Posted: Tue Jan 11, 2005 2:34 pm Post subject:

It works for february to january... And I only need one month difference, because, for instance, there is no point for him to perform some operations pertaining november, since the activities for november were checked on 8th of december. So there is no need for him to try to do them in january (where the validation rule doesn't work for november, or for any month of the previous year, for that matter). So, the only thing that interest me is just the previous month and for that it works now for all months.
_________________
Zaboss
Design for web/print

Mzebonga · Posted: Tue Jan 11, 2005 4:50 pm Post subject:

Why not make a compound variable from the month AND the year?