Date Field reading date as Text

Posted on 2010-01-07
Last Modified: 2013-12-18
I have a database that has 1 form that contains how much someone will be charged for their account. It has a field called Billing_Start. It is a Time/Date field.

When the date is 2008 or greater the field show the date as Time\Date in the document. But if the date is from 2007 it is reading it as Text

The billing view that I have created has the following filter Billing_Start <=@Today.  

I do not want to charge people until the 90 day grace period it up, and that function is working but it is not showing the accounts from 2007.

I have tried @TextToTime(@Text(Billing_Start)) <=@TextToTime(@Text(@Today)) and that does not work either

Any help would be appreciated! Thank you
Question by:kali958
    LVL 46

    Accepted Solution

    What you did would have been my advice, well, almost:
          @TextToTime(@Text(Billing_Start)) <=@Today

    What you could add is a test to find out if Billing_Start really is a date-value.

          x:= @TextToTime(@Text(Billing_Start));
          @If(@IsTime(x); x<=@Today; @True)

    Author Comment

    Perfect - I was on the same path. I did a:=@TextToTime(@Text(Billing_Start) but the part i was really look for was the @IsTime, I did not think to use that one...

    I knew that somehow somewhere there was something to say If it is Time, do this if not then do X.

    Thank you again, this was really helpful!

    Author Closing Comment

    Thanks again for you help, I really appreciate it!
    LVL 46

    Expert Comment

    by:Sjef Bosman
    You might have tried @IsError as well, I suppose it would have worked just as well. Thanks for the kind words. :-)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
    This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now