Date

Ninox Profile

Hi

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

Ninox Profile

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. 

 

Ninox Profile

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

 

Reply