Global date format conversion

Convert any country specific date time format and use it for Query range


UTCDateTime = fromDateTime,  toDateTime;
 ;   
 


fromDateTime    = Global::datetobeginUtcDateTime(fromDateFilter, DateTimeUtil::getUserPreferredTimeZone());







toDateTime      = Global::datetoendUtcDateTime(toDateFilter, DateTimeUtil::getUserPreferredTimeZone());

Use of User Preferred time zones with DateTimeUtil class in DAX

• Fetch only date from UTCDateTime (From user preferred time zone)

static void Job1(Args _args)
{
    date i;
    ;
   
    i= DateTimeUtil::date(DateTimeUtil::applyTimeZoneOffset(DateTimeUtil::utcnow(), DateTimeUtil::getUserPreferredTimeZone()));
    info(strfmt('%1',i));
}

• Fetch only time from UTCDateTime (From user preferred time zone)

static void Job1(Args _args)
{
     str i;
    ;
   
    i =  time2str(DateTimeUtil::time(DateTimeUtil::applyTimeZoneOffset(datetimeutil::utcNow(), DateTimeUtil::getUserPreferredTimeZone())), timeseparator::Colon, timeseparator::Colon);
    info(strfmt('%1',i));
}

•   Fetch the Utcdatetime (with User preferred time zone only)

static void Job1(Args _args)
{
     utcdatetime i;
    ;
   
    i = DateTimeUtil::newDateTime(systemDateGet(), timeNow());
    info(strfmt('%1',i));
}

•   Fetch the Utcdatetime (Without User preferred time zone only)

static void Job1(Args _args)
{
     utcdatetime i;
    ;
    i = datetimeutil::utcnow();
    info(strfmt('%1',i));
}