Hello - trying to convert Accounting Period or Pos...
# accountinga
Adam Panzer
07/05/2023, 3:21 AMHello - trying to convert Accounting Period or Posting Period (ie Oct 2022) to a mm.dd.yyyy format in a saved search - how can I do this? Here is the formula I am trying but it is giving either Error - Field not found or Unexpected Error - to_date(ConCat('01 ', {postingperiod}), 'dd.mm.yyyy')
m
michoel
07/05/2023, 3:27 AMTO_CHAR({accountingPeriod.startdate}, '<http://dd.mm|dd.mm>.yyyy')a
Adam Panzer
07/05/2023, 3:47 AM@michoel returning and "Error - Invalid Expression"
m
michoel
07/05/2023, 3:48 AMWhat type of search is this?
a
Adam Panzer
07/05/2023, 3:48 AMTransaction Search
Adam Panzer
07/05/2023, 3:48 AMI return the Accounting/Posting Period - but need that as a date - so have the formula set to try and return date.
Adam Panzer
07/05/2023, 3:49 AMmessage has been deleted
m
michoel
07/05/2023, 3:50 AMWhy can't you just use the native join for the date?
a
Adam Panzer
07/05/2023, 3:51 AMActually - it works when I use text instead of date
m
michoel
07/05/2023, 3:51 AMYup was about to say that
michoel
07/05/2023, 3:51 AMIf you want a date then just use Account Period Fields... Start Date
a
Adam Panzer
07/05/2023, 3:52 AMPerfect - thanks for your help!
2 Views