mus3na 5 Report post Posted April 30, 2006 assalammualaikum dan salam sejahtera.kali ni aku ada masalah ngan nak manipulate date. maklumla bila read date dari database (MSACCESS) dia hantar dalam format (dd/mm/yyyy). kalau dia hantar ddmmyyyy sahaja senang, aku leh gunakan standard numeric operation utk manipulation, tapi dia ada "/" dalam tu, so payah sikit.aku terpikir nak gunakan cara ASCII cam dalam soalan sebelumni utk buang "/" tapi tak pasti ni cara yg practical atau tidak. so tanya pendapat org yg lebih berpengalaman dulu.contoh program.Date1 = 01/01/2001Date2 = 05/05/2005Date = user input. if Date <= Date1 then operation1 elseif Date >= Date2 then operation2 else operation3 end if so sapa leh guide aku camana nak manipulate date utk operation cam diatas. thanks in advance Share this post Link to post Share on other sites
DevGuy 0 Report post Posted April 30, 2006 ala apa susah22 ko guna format jerrrcontohif Date <= format(Date1,"dd/MM/yyyy") thenoperation1elseif Date >= format(Date2,"dd/MM/yyyy") thenoperation2elseoperation3end ifhaa.. oktry gppd luck thenooko kena retrieve date1 n date 2 tu dari database aaabaru aaa leh check sama ker takkok adiosaaaohaiyooyobasayo Share this post Link to post Share on other sites
hotfloppy 19 Report post Posted April 30, 2006 Date ManipulationatauGoogle Result Share this post Link to post Share on other sites
mus3na 5 Report post Posted May 3, 2006 thanks, korang memang best. tak terpikir lak aku leh pakai format dalam date manipulation. Share this post Link to post Share on other sites