Joined: 30 Oct 2008
Location: United States
Online Status: Offline
Posts: 44
Topic: Excluding fields Posted: 25 Jan 2010 at 1:47pm
I have a date field. Lets call it z_udf_date. I want to pull that date regardless if it is populated or empty from the start of the current month to the current date with the ability to rollover next month so it starts over on Feb 1. I also want to pull that field if it is empty prior to the current month. Does anyone have any ideas? Thank you ahead of time.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 25 Jan 2010 at 2:07pm
If the field is empty (I am assuming it will be considered a null value). Thus if you do a isnull check on in a formula, then you can set it to a value that could be suppressed (providing you do not want to display that value). It really depends what you want to do if it is a null values.
Joined: 30 Oct 2008
Location: United States
Online Status: Offline
Posts: 44
Posted: 25 Jan 2010 at 3:14pm
So far I have {invoice_head.z_udf_date_1}=MonthToDate which bring up all dates starting Jan 1 to current. I now need to add all previous months prior to Jan 1 if that field is empty. Do you know how I incorporate that into my current formula? Thanks!
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum