Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can some one please tell me how to calculate the number of days between today's date and a previous date, such as "CASE_OPEN_DTTM""
In your load script? I'm assuming that the unspecified character string CASE_OPEN_DTTM is the name of a field containing a regular date? Then you can use:
LOAD
:
Floor(today() - CASE_OPEN_DTTM) As NoOfDays,
:
FROM sourcefile.
Best,
Peter
In addition to what Peter mentioned, you can also:
Interval(Now() - CASE_OPEN_DTTM, 'D hh:mm:ss') as TimeBetween
NetWorkDays(CASE_OPEN_DTTM, Today()) as NetWorkDaysBetween