Convert Date

Hi,

is there a method to convert the Date type into a Date type in excel?

The Date type looks like this -> 09 December 2015

And i need something like this -> 09.12.2015

I want to sort the dates in the excel file...

The method "stringOf(Date)" is not what i need...

Re: Convert Date
morast - Wed Dec 09 07:28:42 EST 2015

string ddmmyyyy( Date dDate )
{ // Returns date as string in format DD.MM.YYYY
  dDate = dateOf(intOf(dDate))
  string sDate = dDate ""
  return  sDate[3:4] "." sDate[0:1] "." "20" sDate[6:7]
}


print ddmmyyyy today "\n"

Re: Convert Date
meinhana - Wed Dec 09 07:31:19 EST 2015

string ddmmyyyy( Date dDate )
{ // Returns date as string in format DD.MM.YYYY
  dDate = dateOf(intOf(dDate))
  string sDate = dDate ""
  return  sDate[3:4] "." sDate[0:1] "." "20" sDate[6:7]
}


print ddmmyyyy today "\n"

Thank you :)

Re: Convert Date
Adamarla - Thu Dec 10 05:17:43 EST 2015

You just need to format it with the stringOf function:

Date oDate = today()
print stringOf(oDate, userLocale(), "dd.MM.yyyy")

-Adam

Re: Convert Date
meinhana - Thu Dec 10 05:21:50 EST 2015

Date oDate = today()
print stringOf(oDate, userLocale(), "dd.MM.yyyy")

Thanks, it's easier :)