PHP i can do access!! access is working fine, im trying to get him to replicate my program on PHP.
I just noticed my body subject didnt say PHP only my title!
Sorry :/
PHP i can do access!! access is working fine, im trying to get him to replicate my program on PHP.
I just noticed my body subject didnt say PHP only my title!
Sorry :/
I'm sorry but I did not understand. I don't know how to code in PHP but I do know VBA.
I'm not sure I can help here. Does your Dev know PHP?
PMFJI
Since your Access control is bound to a Date/Time type field, Access understands that any entry in the format of "MM/DD" or "M/D" should be a date. Since the year portion is missing, Access automatically adds/uses the current year.[Date field]
input= 1/1
date = 01/01/2016
input= 1/1/15
date = 01/01/2015
There is code somewhere that handle dates that are after the current date, that sets the year set to 2015 (the previous year).input= 12/12
date DEFAULTS to 12/12/2015 as it is impossible for this task to have been done in the future and my program knows this.
To have PHP do what Access does:
Enter the date into a input box. Example 7/20
Take the entry and parse it into month, day and year components. If no year in entry, set year to current year.
If there is a year component, use the year from the date entry and automatically use format CCYY (CC = 20, YY = 16)
If the month is greater than the current month and there was no year entered, set the year to the previous year.
Replace the entry with the result.
So, current date is Aug,2,2016
Enter 7/20 in input box
Parsed, it becomes Month = 7, day = 20, year = missing, so enter current year.
Result = 7/20/2016
Enter 7/20/15
Parsed: Month = 7, day = 20 year = 2015
Result = 7/20/2015
Enter 10/6
Parsed: Month = 10, Day = 6 Year = missing so use current year (2016)... but since current Month = 8, use the previous year
Result = 10/6/2015
Is this close?? I can somewhat read PHP, but I have not learned (yet) how to program in PHP..... yet another thing on the bucket list...
Thanks for jumping in Steve.