Corel paradox call method in library9/24/2023 ![]() The iif() function lets you define a condition and will return one of two values based on whether or not that codition is true. ![]() The more traditional accounting of Monday as the first day of the week makes this calculation easier.Ĥ. While this is a legimate choice, it makes things more difficult. Note that Paradox defines Sunday as 1 and Saturday as 7. The dowOrd function returns an integer indicating the numeric weekday that a given day falls on. ![]() The same thing is true when the original DateSeen falls on a Saturday, though you really want a date 13 days in the future.ģ. When you're starting with a Sunday date, you're looking for a date 12 days in the future, e.g. Iif( dowOrd( fldDateSeen.Value ) = 7, -1, 0 )Note that I've broken that into three lines for presentation here when you enter it, be sure to type it as a single line.ġ. Iif( dowOrd( fldDateSeen.Value ) = 1, -2, 0 ) +
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |