Account expiry dates

[andrewnorris]

Hello

We currently import our users from active directory to SNC via the LDAP plugin. I want to bring over the account expiry dates too but as this is stored in Integer8 format it will need some transform scripting to get it to show a human-readable date format.

I'm afraid I have no idea how to convert Integer* to the current date format. Can anyone offer help or guidance?

Thanks
Andy

[jesusemelendezm]

Scott, where did you go to change the Expiry Date field on the user table from Glide Date Time, to Glide Date??? from the table editor. I only see two type of data "date" and "date/time".

Rgards

[Scott_Lathlean]

Hi Jesus,

I set the field type on dictionary entry for the custom Expiry Date field to 'Date', rather than 'Date/Time'

Cheers

- Scott

[jesusemelendezm]

Thanks I will give a try.

Regards

[jesusemelendezm]

Same thing, It is showing the date with 1 day ahead.

[jesusemelendezm]

Any idea what could be causing that issue?