Member Avatar for Lokesh.snghl

hi guys,
I m devloping a program To calculate tavell alowance and driving alowance,But i have some problem to calculate it.
for it i m making structure of database

Sourec(CITY) Destination(CITY) startDate enddate mode
A B 5\14\2008 5\15\2008 SAME STATE
B D 5\20\2008 5\21\2008 OTHER STATE
D B 5\22\2008 5\22\2008 OTHER STATE
B A 5\14\2008 5\15\2008 SAME STATE

CALCULATE DAYS B/W
1.SOURCE CITY A TO DESTINATION B
1.SOURCE CITY D TO DESTINATION B
1.SOURCE CITY bTO DESTINATION a

  • 2 Contributors
  • 1 Reply
  • 66 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by greeny_1984
Member Avatar for greeny_1984

go to database forum,it will be more helpfull

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.