0

Date Format

Newman Cui

September 18, 2018 04:17

None

Follow

Hi, this NP formula returns the date, but it is not in date format. 

=NP("Formula","=IF(ISNUMBER(search(CREDITOR,[@[Payment Terms]])),EOMONTH([@[Due Date]],0),EOMONTH([@[Due Date]],1))")

If I want to use TEXT to change to date format, how should I do it? or is there a better way to do it? 

Thanks. 

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Harry Lewis September 18, 2018 14:12

  Hello Newman -

  I would expect it to look something like this:

  =NP("Formula","=IF(ISNUMBER(search(CREDITOR,[@[Payment Terms]])),TEXT(EOMONTH([@[Due Date]],0),""MM-DD-YYYY""),TEXT(EOMONTH([@[Due Date]],1),""MM-DD-YYYY""))")

  (adjusted, of course, for what date format you want to display).