Finding a remainder after division

-

hi.

 

so i've solved problem it's not elegant. got better way find age (in case on date 1st april 2013) , state in format "00y 00m" (years , months) easy reading?

 

here's solution:

 

trunc((datevalue("1/9/13") - 'dob') / 365.24) & "y " & trunc(12 * (((datevalue("1/9/13") - 'dob') / 365.24) - trunc(((datevalue("1/9/13") - 'dob') / 365.24)))) & "m"

 

...where 'dob' field name containing datevalue (the person's date of birth).

 

i couldn't find 'modulus' function, or "\" (remainder rather divide "/") operator or neat way sub-calculation... perhaps need one?

 

thanks.

this doesn't seem has formscentral. application doing coding in?



More discussions in Archived Spaces


adobe

Comments

Post a Comment

Popular posts from this blog

2.5.28 to 3.4.1---Download of update package failed - Joomla! Forum - community, help and support

-
went 2.3* whatever 2.5.28 same message.. had install via extension manager: install.. seemed work fine.. updated extensions , db.. tried run install again joomla! update module , download of update package failed message.. tried install extension manager: install. again , nothing.. don't seem have jommla_update.php file on server.. using godaddy plesk.. fun installed 3.4.1 on server using godaddy applications , worked fine.. i have seen server might out of space.. not issue here. permissions set correctly can tell. i new take easy on me.. any ideas? viewtopic.php?f=621&t=582860 Board index Joomla! 3.x - Ask Support Questions Here Migrating and Upgrading to Joomla! 3.x
Read more

Warning, the Safe Path is not accessible vm3 - Joomla! Forum - community, help and support

-
i have install virtumart 3 , safe path error (vmerror: warning, safe path not accessible (does not exist or no permission), safety reasons important create folder in path not accessible url or unguessable name, create folder 'invoices' , 'keys' in store sensitive data secure. our suggested path system '/home/shop3/vmfiles/'. you can use complex folder name 'password' example '/home/shop3/public_html/administrator/components/com_virtuemart/pgq9b3kscpin/'. use link config) does have idea why, if created folder, can't warning out? virtumart virtuemart 3.0.8 joomla! 3.3.6 stable problem solved Board index Joomla! 3.x - Ask Support Questions Here Extensions for Joomla! 3.x
Read more

uppercase letters in url - Joomla! Forum - community, help and support

-
hello all, i in process of migrating joomla 2.5 1.5. 1 of categories in 1.5 version had capital letters in name. in joomla 2.5, uppercase letters in article/menu/category alias automatically converted lowercase. i tried changing menu alias in database, caused 404 error in category-blog page. i have been trying many days find solution, reason being many of pages category in 1.5 site have lots of facebook likes don't want lose. does work-around exist allow me manually change category/menu alias category blog page , articles have category name uppercase letters? any appreciated. thanks! you can 301 redirect uppercase urls lowercase. Board index Joomla! Older Version Support Joomla! 2.5 Search Engine Optimization (Joomla! SEO) in Joomla! 2.5
Read more