0

Date

Hi

date is : 4 oct 2018 , i want be 04102018.  How can do it?

2 replies

null
    • Mconneen
    • 5 yrs ago
    • Reported - view

    Here ya go..  This is called out in this part of the manual.. 

    https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language

    Then search for "format".. Basically .. You just strip of the date parts .. and put them back together. 

    dates

    format(Day, "00") + format(Month, "00") + Year

    Obviously ... You can embed each of the functions .. Like

    formate(day('Start Time'), "00") .. 

    your call.

    Oh.. There is another thread on the User forum about why / how the default date display .. It is based on your computer's system preference. 

    • Mconneen
    • 5 yrs ago
    • Reported - view

    CRAP.. Need new glasses.. "strip of".. should be "strip OFF".. :( 

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 1426Views