Lookup a date in a UD table where the date is stored as Microsoft number


(Marty Fleming) #1

Hi all

I am trying to look up a date in a UD table where the date is stored in Microsoft DateValue format. I want to use the need by date off an order header to look up a date formatted like 42748 and then return another field back to the BPM.

Does anybody know how to convert the need by date in an expression?

Any help would be much appreciated.

Thanks
Marty


(Jose C Gomez) #2

Assuming you are referring to this serial date value.

https://support.office.com/en-us/article/datevalue-function-df8b07d4-7761-4a93-bc33-b7471bbff252

January 1 1900 is the base date. Simple math should take care of the rest
-Jose