same date this year

Belias

Is there a better way to do this?

IF DMY2DATE(DATE2DMY(TBBaseCal.Date,1),DATE2DMY(TBBaseCal.Date,2),DATE2DMY(TODAY,3)) = TODAY THEN

I'm trying to transform a date from, for example, 12/02/03 to 12/02/08...

kriki

IF (DATE2DMY(TBBaseCal.Date,1) = DATE2DMY(TODAY,1)) AND
    (DATE2DMY(TBBaseCal.Date,2) = DATE2DMY(TODAY,2)) THEN

Well, the IF is still complicated, but it is more clear what you want to do.

BGI

Maybe something like this:

IF CALCDATE('<+1Y>',TBBaseCal.date) = today then...

Belias

sure...so you think that dmy2date and date2dmy is the only way...
if anyone have other ideas they're welcome...
for now...thanks kriki...this is better than my "if" 8)

Belias

BGI wrote:

Maybe something like this:

IF CALCDATE('<+1Y>',TBBaseCal.date) = today then...

right...if i know the nuber of years between the dates...but i don't know it...i can calculate it but the complication will remain the same

DenSter

Belias wrote:

sure...so you think that dmy2date and date2dmy is the only way...
if anyone have other ideas they're welcome...

Is there a problem with that solution? It appears that you don't like this solution and I'm curious why.

Belias

i wasn't satisfied by my solution...kriki's one is far better than mine.
I was only wondering if there were something different with date table or whatever else...in order to learn something new

kriki

As (almost) always : there are multiple solutions.
Some more beautiful than others. Some better, some less. But mostly these depend on the tastes of the programmers.

Belias

kriki wrote:

As (almost) always : there are multiple solutions.
Some more beautiful than others. Some better, some less. But mostly these depend on the tastes of the programmers.

right!and whatever method you use, you can [solve] your problem!