Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Date Format needs adjustment
#3
Solved: 10 Years, 9 Months ago
Hi ,

Try in the below way Smile

Code:
Dim TestDate
  TestDate = DateAdd("d", -65, Date)
  dpart=datepart("d",TestDate)
  mpart=datepart("m",TestDate)
  ypart=datepart("yyyy",TestDate)
  
  Final_TestDate=dpart&"."&mpart&"."&ypart
  msgbox Final_TestDate
Reply


Messages In This Thread
Date Format needs adjustment - by unbeliever - 01-15-2010, 01:05 PM
RE: Date Format needs adjustment - by unbeliever - 01-15-2010, 02:11 PM
RE: Date Format needs adjustment - by sreekanth chilam - 01-15-2010, 03:04 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How to change 24 hrs time format to 12 hrs time format Varsha Gupta 1 2,653 04-21-2018, 11:06 AM
Last Post: Ankur
  How to validate a format of an alphanumeric string PrateepKaraval 2 5,808 11-08-2014, 10:26 AM
Last Post: vinod123
  How to validate date in an application should not accept less than future date. ruchi03 1 3,474 10-08-2014, 05:54 PM
Last Post: rajkumarsm
  Date Picker Issue - Unable to select date link dynamically rajkumarsm 1 4,991 09-20-2014, 09:31 AM
Last Post: rajkumarsm
  Pdf to Excel or any other Format Conversion branjitk 1 2,337 06-14-2012, 08:14 AM
Last Post: basanth27

Forum Jump:


Users browsing this thread: 1 Guest(s)