Compares dates

[Sigal Laniado]

How do i compare 2 dates with the format "dd\mm\yy"?

[Dr_Michael]

suppose we have date1 and date2:

a=format(date1,"yyyymmdd"
b=format(date2,"yyyymmdd"
if a>b then max=a else max=b




Michael Vlastos
Automation Engineer
Company SouthGate Hellas SA
Development Department
Athens, Greece

[Dr_Michael]

I can say I am a "date specialist". Ask me whetever you need about dates. I have a lot experience on such subject... Maybe I can help you. Did it work for now?

Michael Vlastos
Automation Engineer
Company SouthGate Hellas SA
Development Department
Athens, Greece

[Sigal Laniado]

Thanks for your help!. It helps me althought I found the "DateDiff" function which also do the work.
If I will have more questions about dates I will not hesitate to ask you directly!
anyway thank you.