Forum Discussion

Jan-WillemSpeck's avatar
Jan-WillemSpeck
Qrew Assistant Captain
7 years ago

Check presense of date/Time field? | IF in DateTime field gives syntax error

Hi there QB-community, I'm trying to build something around timekeeping. In my design I have 2 date/time fields to get a start DateTime value from the user. One field is created as a timestamp th...
Formulas and functions
reports and charts
Jan-WillemSpeck's avatar
Jan-WillemSpeck
Qrew Assistant Captain
7 years ago
Ah thanks 'not isnull' ... everytime again you learn me something new :-)

about an hour off puzzling brought me to this solution that also seems to work
If(Day(ToDate([StartTime_TimeStamp]))<32,[StartTime_Manual],[StartTime_TimeStamp]).
I must admit yours is less coding and conversion thus possibly better/cleaner

We just finished dinner on my end.. so I continue my quest.. let's see what works best in the end.
I'll let you know.




  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    The goal is to write formulas with the least code yet most understandable for the long term.

    Some poor soul years in the future, perhaps even you, will one day need to adjust this formula or see what logics it�s using so you want to have formula very obvious to someone looking at it for the first time.